displaying text & value in same cell

R

Roland

How can I display text such as "Today's total is:"
followed by the result from another cell or from a
formula, all within that same cell?
 
D

DDM

Roland, some examples:

="Today's total is: "&G7

="Today's total is: "&SUM(B2:B4)

The ampersand (&) ties them together.
 
R

Roland

Thank you for the info. When I concatenate, how can I keep
the formating used in the value cell, ie. $5,455.55.
Presently, I get Today's total is: 5455.55. I can include
the $ in the " marks but I can't figure out how to keep
the currency formating. Thanks for any help.

Roland Moessner
 
Top