Adding Text To Formula's

[Guest]

How do you add text to a formula? For example, if a formula in C1 calculates A1+B1, how can I get C1 to add the word "points" to the end of the calculation?

 

[Aladin Akyurek]

On 2002-03-01 10:32, Anonymous wrote:
How do you add text to a formula? For example, if a formula in C1 calculates A1+B1, how can I get C1 to add the word "points" to the end of the calculation?

=(A1+B1)&" points."

 

[Mark W.]

Also, you could use the formula, =A1+B1, and format the cell C1 as...

General" points"
This message was edited by Mark W. on 2002-03-01 11:01