Text sentence with a formula ... is it possible

[cmm]

I want to have in one cell for example:

The wagon is at a cost of $

after the dollar sign I want to have a formula referenced
from another cell. Is this possible?

Thanks.

 

[Max]

Assuming the text phrase "The wagon is at a cost of $" is in A1,
and in A2 is a formula, say: =SUM(E1:F1) evaluating to say, a number 3, then

:=A1&A2
gives "The wagon is at a cost of $3"

:=A1&TEXT(A2,"#,##0.00")
gives "The wagon is at a cost of $3.00"

 

[CLR]

Right-click on your cell, Format > Custom > in the window type "The wagon is
at a cost of $###.## > ok
then, put whatever formula you want in the cell and it will read as you
desire......

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

sorry, left out a "
should be
"The wagon is at a cost of $"###.##

Vaya con Dios,
Chuck, CABGx3