"Herbert Seidenberg" wrote...
This could be done without any formulas:
Select cells plus top blank row.
....

So OP may need to insert a blank row above the data.

Edit Find Options Format Choose Format from Cell
Select any white cell Find All SHIFT+END Close
....

This requires Excel 2003, doesn't it?