Hi,
Select your cells containing the formulas then go to Edit/Find, in the
"find what" box type and leave the "replace with" box empty, hit
"Replace All"

About copying a formula, I'm assuming you want to display the result of
a formula from a worksheet in another worksheet, if so then use Paste
Special and select "paste link"

Hope this helps!
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=473182