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

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

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

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

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

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

"Allllen" wrote:

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

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

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

Select all cells then F5SpecialBlanksOK

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

On Thu, 9 Nov 2006 11:32:02 -0800, hccatmo
wrote:

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

"Allllen" wrote:

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