P
Phil Hageman
I want to add text after the results of a formula - something like: =C3 + "Units". What would the formula be?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
Phil,
Use the & character. E.g.,
=C3&" Units"
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
message
Use the & character. E.g.,
=C3&" Units"
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
message
like: =C3 + "Units". What would the formula be?I want to add text after the results of a formula - something
A
Alan
=C3&"Units"
or
=C3&" Units"
or
=C3&" Units"
"Units". What would the formula be?Phil Hageman said:I want to add text after the results of a formula - something like: =C3 +
F
Frank Kabel
Hi
you're nearly there:
=C3 & " Units"
you're nearly there:
=C3 & " Units"
something like: =C3 + "Units". What would the formula be?-----Original Message-----
I want to add text after the results of a formula -
B
Bob Phillips
=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)
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)
"Units". What would the formula be?Phil Hageman said:I want to add text after the results of a formula - something like: =C3 +