How do I remove blank cells from a column of numbers?

K

Kanga 85

I have a long column of numbers, including many blank cells. I need to
remove the blank cells (delete and close up), or alternatively produce a
second (shorter) column containing only the list of numbers with no blank
cells.
 
M

Myrna Larson

Use Data/AutoFilter on this column, choosing Blanks. Then delete the rows.

On Tue, 19 Oct 2004 20:09:03 -0700, "Kanga 85" <Kanga
 
Top