You can do it right in the same column.

Select your range
Hit F5
Click "Special"
Click "Blanks"
Then <OK
Type the Equal (=) sign
Hit the UpArrow
Hit <Ctrl <Enter

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steve C" wrote in message
...
I need to replace null values in all the cells of a column with the value
in
the cell directly above it. Can I run something in the next column to
accomplish this?

Example:
A B
1 $5
2
3 $3
4 $7
5

Desired Result:
Example:
A B
1 $5 $5
2 $5
3 $3 $3
4 $7 $7
5 $7