Adding Text To Formula's

Mar 1st, 2002, 11:32 AM

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 · Mar 1st, 2002, 11:49 AM

Quote:

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. · Mar 1st, 2002, 12:01 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 1st, 2002, 11:32 AM	#1
Guest Posts: n/a	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?

Mar 1st, 2002, 12:01 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]