How do i get rid of blank cells in a column

[mrclox]

as the subject says really, i have a column with data with blank cells every few cells.

is there an easy formula to put them in another column without blank cells

thanks in advance steve

 

[lenze]

Do you want to delete the row with the blank cells, or only remove the blank cells and shift the ones below up?

In either case, a search of the board should provide ample examples of each.

lenze

 

[NBVC]

Copy the column as is first to your desination,

Then highlight the whole range within the new column, including blanks.

Then go to EDIT|GO TO and click Special. Select Blanks radio button and click OK. (all blanks should be highlighted). Now right-click one of those blank highlighted cells and select Delete. From the pop-up select Shift cells up.