Dave

Copy the third column and then EditPaste special...Values and number
formats over the original data. This will kill the formulas allowing you to
delete the referenced cells

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Dave" wrote in message
...
I have used two columns to creat a third column. I want to save the third
column and delete the first two columns used to create the third. When I
try
to do this, I receive the message, #REF!. Program help wasn't much help.
Thank you