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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hccatmo - 09 Nov 2006 16:30 GMT

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

Reply to this Message

Allllen - 09 Nov 2006 16:39 GMT

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

Signature

Allllen

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

Reply to this Message

hccatmo - 09 Nov 2006 19:32 GMT

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

> if column A has your data starting in cell A2
>
[quoted text clipped - 14 lines]
> > Thanks.
> > cg

Reply to this Message

Gord Dibben - 09 Nov 2006 20:52 GMT

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

>Thank Allllen.
>I am looking for way to change all columns and all rows using R1C1 and
[quoted text clipped - 19 lines]
>> > Thanks.
>> > cg

Reply to this Message