Concatenated Formula
 

I want to add text after the results of a formula - something like: =C3 + "Units". What would the formula be?

Concatenated Formula
 

Phil,

Use the & character. E.g.,

=C3&" Units"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Phil Hageman" wrote in
message
...
I want to add text after the results of a formula - something
like: =C3 + "Units". What would the formula be?

Concatenated Formula
 

=C3&"Units"
or
=C3&" Units"
"Phil Hageman" wrote in message
...
I want to add text after the results of a formula - something like: =C3 +
"Units". What would the formula be?

Concatenated Formula
 

Hi
you're nearly the
=C3 & " Units"

-----Original Message-----
I want to add text after the results of a formula -
something like: =C3 + "Units". What would the formula be?
.

Concatenated Formula
 

=c3 & " Units"

you might need to format the number like

=TEXT(C3,"#,##0.00") & " Units"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Phil Hageman" wrote in message
...
I want to add text after the results of a formula - something like: =C3 +
"Units". What would the formula be?