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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
How do I remove blank cells from a column of numbers 9
Find previous number and find next number in column 4
Sorting a list of numbers 3
VLOOKUP returns 0 (zero) when lookup cell is blank 5
Counting Non Blank Cells 4
Validation list with non blanks from different column 3
Excel 2003 - Skip a cell 5

Back
Top