text and formula in the same cell for excel

[Guest]

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?

 

[Frank Kabel]

Hi
try
="Two time tow is: " &A1*B1

 

[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

 

[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)