Replace all empty or " by the content of the cell above it

H

hccatmo

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

Allllen

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
 
H

hccatmo

Thank Allllen.
I am looking for way to change all columns and all rows using R1C1 and
relative addressing.
cg
 
G

Gord Dibben

For truly empty cells...........

Select all cells then F5>Special>Blanks>OK

In active cell type an = sign then point to cell above.

Hit CTRL + ENTER

Cells with "" returned via formula are not considered "empty".


Gord Dibben MS Excel MVP
 
Top