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