How do I remove blank cells from a column of numbers? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Kanga 85 10/19/2004 8:08 PM PST   Question   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.     Was this post helpful to you?         Reply |   Top           Myrna Larson 10/19/2004 8:28 PM PST   Answer   Use Data/AutoFilter on this column, choosing Blanks. Then delete the rows. On Tue, 19 Oct 2004 20:09:03 -0700, "Kanga 85" <Kanga 85@discussions.microsoft.com> wrote: >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.     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies