Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenated Formula
I want to add text after the results of a formula - something like: =C3 + "Units". What would the formula be?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenated formula help | Excel Worksheet Functions | |||
Past Special Concatenated formula | Excel Discussion (Misc queries) | |||
cannot get concatenated formula to evaluate... | Excel Discussion (Misc queries) | |||
specify range name in formula with concatenated string | Excel Worksheet Functions | |||
concatenated text to formula | Excel Discussion (Misc queries) |