displaying text & value in same cell

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

 

[Don Guillett]

try this
="the ans is "&R2*2
or leave off the *2 for just cell r2

 

[otium]

=CONCATENATE("Today's total is : ",A1

 

[DDM]

Roland, some examples:

="Today's total is: "&G7

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

The ampersand (&) ties them together.

 

[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

 

[Don Guillett]

try
="the ans is "&DOLLAR(R2*2,2)

 

[Roland]

Thank you!!!

-----Original Message-----
try
="the ans is "&DOLLAR(R2*2,2)
--
Don Guillett
SalesAid Software
(e-mail address removed)



.

 

[Don Guillett]

glad to help