Remove the fomula...?
 

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

Remove the fomula...?
 

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.

"Donald King" wrote:

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

Remove the fomula...?
 

Copy.

Paste SpecialValuesOKEsc.


Gord Dibben MS Excel MVP

On Fri, 10 Nov 2006 13:39:01 -0800, Donald King
wrote:

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

Remove the fomula...?
 

Hi donald...try copypaste column C into column A or Delete Column A and
Column B.

"Donald King" wrote:

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

Remove the fomula...?
 

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

"rml" wrote in message
...
Hi donald...try copypaste column C into column A or Delete Column A and
Column B.

"Donald King" wrote:

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