My data table has extra spaces

From: Jeff Crocker (JeffCrocker_at_discussions.microsoft.com)
Date: 07/17/04 

Date: Sat, 17 Jul 2004 11:58:03 -0700

How can I get rid of extra blank spaces or cells in my columns? if I have a column with 26 numbers in it and the next column has letters "a b c d & f" in the column.

the data will display 1-26 correctly but the column with the letters will display
a in cell 1, b in cell 2, c in cell 3, and d in 4, but will add a blank cell in and then display f in cell 6 . I have tried to sort etc. and cant lock the data. if I add an age column to say 65yrs old it really messes up all the other data. Can anyone help me?

Thanks Jeff!

Relevant Pages

  • Re: Vector Table
    ... But there is no data displayed in any of the "cells". ... can be numbers or letters or puncuation or whatever. ... details of what's in the cell and how to display it. ... Just because you have an array Xdoesn't ...
    (comp.lang.cpp)
  • Re: How do I find data excluded from a list in excel?
    ... Microsoft Excel MVP ... to display in cells C8 to 11 the data that have not been selected in ... Or a simplified version of the above: Let say I have the letters "A" in ... In cell C4 I want to display the letter that has not been ...
    (microsoft.public.excel.misc)
  • Re: How do I find data excluded from a list in excel?
    ... Hold down both the CTRL key and the SHIFT ... to display in cells C8 to 11 the data that have not been selected in cells ... Or a simplified version of the above: Let say I have the letters "A" in ... In cell C4 I want to display the letter that has not been ...
    (microsoft.public.excel.misc)
  • Re: How do I find data excluded from a list in excel?
    ... Based on your first description enter this array formula** in C8 and copy ... to display in cells C8 to 11 the data that have not been selected in cells ... Or a simplified version of the above: Let say I have the letters "A" in ... In cell C4 I want to display the letter that has not been ...
    (microsoft.public.excel.misc)
  • Re: How can I dynamically eliminate blank cells in a given range in E.
    ... Formulas can't "get rid" of blank cells - but you can use formulas to ... display a list without blanks from a range that includes blanks, ...
    (microsoft.public.excel.worksheet.functions)