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