You've got 2 responses to your identical post in .public.excel

--
Rgds
Max
xl 97
--
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
---
"Wesley" wrote in message
...
I have one column with a formula in multiple rows within the same column.
The formula pulls data from other parts of the spreadsheet or leaves the
cells blank. An example of the formula is =if(A1=0,"",A1).

The outcome is to have a column with data in multiple rows mixed with
blank
cells like so.

Bob
Mary
"Blank"
Joe
"Blank"
Jill

What I would like to do is pull the data automatically from this column
putting the data in another column excluding the "Blank" cells like so:

Bob
Mary
Joe
Jill

Any help would be most appreciated.

Thank you,

Wesley