Reformation after CONCATENATE procedure Q.

[usmleboy]

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

[Lilliabeth]

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.

[Bob Phillips]

Copy the column with the formula
Edit>PasteSpecial>Values
Then delete the original columns

--

HTH

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


"usmleboy" <[email protected]> wrote in message
news:[email protected]...
> 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
>