Try something like this:

Select the range of formulas interspersed with blanks

Press the [F5] key.......that's the shortcut for <edit<go to
Click [Special]......Check: Blanks......click [OK]

While the blanks are selected....
Type =
.....press the UP arrow one time
....Hold down the [Ctrl] key and press [enter]

That's it....each formerly blank cell now contains a formula referencing the
cell directly above it.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"audif" wrote:

I would like to know how to set up a formula that will find a blank cell in a
column and fill in that cell with the infomation (text) that is found in the
cell directly above it.