G Guest Apr 26, 2004 #1 I want to add text after the results of a formula - something like: =C3 + "Units". What would the formula be?
I want to add text after the results of a formula - something like: =C3 + "Units". What would the formula be?
C Chip Pearson Apr 26, 2004 #2 Phil, Use the & character. E.g., =C3&" Units" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com message I want to add text after the results of a formula - something Click to expand... like: =C3 + "Units". What would the formula be?
Phil, Use the & character. E.g., =C3&" Units" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com message I want to add text after the results of a formula - something Click to expand... like: =C3 + "Units". What would the formula be?
A Alan Apr 26, 2004 #3 =C3&"Units" or =C3&" Units" Phil Hageman said: I want to add text after the results of a formula - something like: =C3 + Click to expand... "Units". What would the formula be?
=C3&"Units" or =C3&" Units" Phil Hageman said: I want to add text after the results of a formula - something like: =C3 + Click to expand... "Units". What would the formula be?
F Frank Kabel Apr 26, 2004 #4 Hi you're nearly there: =C3 & " Units" -----Original Message----- I want to add text after the results of a formula - Click to expand... something like: =C3 + "Units". What would the formula be?
Hi you're nearly there: =C3 & " Units" -----Original Message----- I want to add text after the results of a formula - Click to expand... something like: =C3 + "Units". What would the formula be?
B Bob Phillips Apr 26, 2004 #5 =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 said: I want to add text after the results of a formula - something like: =C3 + Click to expand... "Units". What would the formula be?
=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 said: I want to add text after the results of a formula - something like: =C3 + Click to expand... "Units". What would the formula be?
