text and formula in the same cell for excel

J

JonARosen

I am trying to do text and a small math formula in a single cell.

Simply enough something like: "Two times Two is" =2*2 or preferably Cell*Cell

Is this possible? and if so, how do I set it up so that the text stays text,
but the formula isn't read AS text?
 
B

Biff

Hi!

Maybe something like this:

="Two times two is "&2*2

or with cell references:

="Two times two is "&A1*B1

Now, this will evaluate to TEXT because that's exactly
what it is. The cell contains a formula that returns a
TEXT string.

Biff
 
D

Dave Peterson

And one more if you need to format the results.

="Two times two is: " & text(a1*a2,"0.00") & " for today: "
& text(today(),"mm/dd/yyyy")

(all one cell)
 
Top