Remove the fomula...?

[Guest]

Anyone know how to remove the formula and leave the data?
I filled a column A3 with an IF(B3="",C3,B3). Now I want to remove the IF
function but leave the data that was replaced.

Tks,
Don

 

[Guest]

What I normally do is copy the data then 'paste special' ..... 'values' and
paste right over top of the formula. This will copy the values overtop of
your formula.

 

[Gord Dibben]

Copy.

Paste Special>Values>OK>Esc.


Gord Dibben MS Excel MVP

 

[Guest]

Hi donald...try copy>paste column C into column A or Delete Column A and
Column B.

 

[David Biddulph]

If you do that you'll lose the data. You need to use Paste Special/ Values.