I've been trying to find a way to put text AND a forumla in one cell..

ie: The value of so&so [=SUM(c6+e8)] or the like... is this possible at all?
I've never found anything that seems to be able to manage this. obviously the
format would have to be text, but there would be a way, I imagine, to insert
a number as text into a text format.

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

="the value of so and so is: " & sum(c6,e8)

or
="the value of so and so is: " & text(sum(c6,e8),"0.00")

or
="the date that it's due is: " & text(a1,"mm/dd/yyyy")



JonARosen wrote:

I've been trying to find a way to put text AND a forumla in one cell..

ie: The value of so&so [=SUM(c6+e8)] or the like... is this possible at all?
I've never found anything that seems to be able to manage this. obviously the
format would have to be text, but there would be a way, I imagine, to insert
a number as text into a text format.

--

Dave Peterson