How do I remove blank cells from a column of numbers

[Guest]

I have a long column of numbers which cotins many blank cells. I want to
remove all blank cells, providing a shorter list contining only numbers

 

[Frank Kabel]

Hi
try:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

I have a long column of numbers which cotins many blank cells. I want to
remove all blank cells, providing a shorter list contining only

numbers

 

[Bob Phillips]

Data>Filter>Antilitter select blanks and then delete the visible rows (blue
row number on mine)

 

[Guest]

Couldn't you just sort ascending to get only the numbers?

 

[Gord Dibben]

Select the column then F5>Special>Blanks>OK

With blanks selected Edit>Delete>Cells>Shift Up.

Or Delete>Entire Row.

Gord Dibben Excel MVP

 

[Guest]

Thanks for all help. I don't want the data sorted; just the blanks removed.

 

[Guest]

Thanks Bob, but I have Excel 2002 (for XP) and can find no Antilitter command.

 

[Alex Delamain]

Alternatively

Data Filter Autofilter then filter for Blanks and then delete the row

 

[Gord Dibben]

Kanga

Select the column.

Edit>Go To>Special>Blanks>OK

Edit>Delete>Entire Row.

Gord Dibben Excel MVP

 

[Bob Phillips]

Sorry that is the spellchecker, should be Autofilter