I need to convert a formulated text into text

Microsoft Excel 2003 (full product)
December 16, 2010 at 16:42:54
Specs: Windows XP
I need to convert a formulated text into text only, I am using Excel 2003.
Here is an example:
Column A, Row 1: Apple
Column B, Row 1: Sauce
Column C, Row 1: =a1&b1
Column C text would be AppleSauce

Your assistance is appreciated.


See More: I need to convert a formulated text into text

Report •

#1
December 16, 2010 at 17:50:38
If you mean to convert the result of the formula into real values, then:

Select cell C1
Select Copy
Select Past Special
Select Values
Click OK

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question