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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use Data/AutoFilter on this column, choosing Blanks. Then delete the rows.

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