if column A has your data starting in cell A2

add a new column B

then in cell B2 do this
=IF(A2="",B1,A2)
and extend the formula down column B

now copy column B
Select column A
edit paste special values

now delete the column B you no longer need
--
Allllen


"hccatmo" wrote:

Good morning,
I wish to replace all empty ot cells with " to the value of the cell above it.
Thanks.
cg