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