impossible way to do something?
 

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.

impossible way to do something?
 

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

impossible way to do something?
 

="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