Formula conversion, result to text

[John]

Hello,

I have a few cells which I need to have the actual result
converted into text, instead of showing the formula on
top of the page.

Cell A3 = 'DVD-0002'
Cell B3 = '2'
Cell C3 = "-1"
Cell D4 Formula = 'A3&""&B3' displays 'DVD-0002-2'
Cell D5 Formula = 'A3&""&C3' displays 'DVD-0002-1'

As I will be saving the sheet as a text file, for Tab
Delimited, I need the cels in D4 & D5 to be the actual
displayed, not referencing the formula.

I could use help with this.

Thanks!

 

[Guest]

copy the formulas and paste as values before you save the
workbook.

 

[Gord Dibben]

John

Copy D4 and D5 then Paste Special>Values(in place)

Gord Dibben Excel MVP