compress cells

[Guest]

i have a number of records in a list in a column. I need to compress the
records so that all the records bunch up.

e.g.

rec1

rec2

rec3

becomes...

rec1
rec2
rec3

is there an automatic way to do this? i have rather a lot of records to do
it for!

rgds,

Tom

 

[Gordon]

i have a number of records in a list in a column. I need to compress the
records so that all the records bunch up.

e.g.

rec1

rec2

rec3

becomes...

rec1
rec2
rec3

is there an automatic way to do this? i have rather a lot of records to do
it for!

rgds,

Tom

Do I assume there is a space between "rec" and the number? (It's a bit
hard to see from your post!) If so, just do a Find and Replace. Find
"space" and replace with "" (nothing)

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!

 

[Guest]

There may well be an easier way to do what you need, but all I can think of
is this:

Create a blank column to the left of your list. For the sake of argument,
assume that your list is in column "B" and the blank column is column "A".
Also assume that your list starts in row 2. Put the following formula in A2
and copy it down.

=IF(B2="","",ROW())

Now merely sort columns A and B (using A as the sort key) -- for only the
rows containing your list of course. The get rid of column A.

Art

 

[Gord Dibben]

Tommy

Select the column.

Hit F5 then Special>Blanks<OK

Edit>Delete. Shift cells up or if nothing in other columns, Delete entire
row.


Gord Dibben Excel MVP