If I am understanding you correctly then you want to do something
similar
to the following:

you have a number in A1 and B1 and you want to sum those to numbers
and
in the process put "The answer is" in front of the result.

A1: 2
B1: 2
C1: The answer is 4

In C1 you would put ="The answer is "&A1+B1

In more generic terms it would look like:

="[Your text]"&[Your formula]

Does this help?


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=507416