Hi Friends,

I have a problem with my data. After CONCATENATE procedure (from two
columns) I obtained needed result, but after deleting initial data the
resulted column was changed to "ref". Would you mind to recommend me
something to deal with this problem? As far as you understand there should
not be other data in my spreadsheet except for final result.

Thanks in advance
Daniel

Copy the column with the formula
EditPasteSpecialValues
Then delete the original columns

--

HTH

RP
(remove nothere from the email address if mailing direct)


"usmleboy" wrote in message
...
Hi Friends,

I have a problem with my data. After CONCATENATE procedure (from two
columns) I obtained needed result, but after deleting initial data the
resulted column was changed to "ref". Would you mind to recommend me
something to deal with this problem? As far as you understand there should
not be other data in my spreadsheet except for final result.

Thanks in advance
Daniel

Put the columns back
Select your concatenate formulas and hit the Copy button
Then go to the menu and Click Edit Paste Specials
In the Paste Special dialog box, choose values.

This will overwrite the formulas with the values that were produced by
the formulas, so you can now delete the original data.


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=499046