Tommy
Select the column.
Hit F5 then SpecialBlanks<OK
EditDelete. Shift cells up or if nothing in other columns, Delete entire
row.
Gord Dibben Excel MVP
On Thu, 3 Feb 2005 04:11:06 -0800, "tommy"
wrote:
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
|