Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I capitalize and parse in the same formula?
I need to write a formula that does 2 functions, LEFTand UPPER. Is this
possible? I need to "grab" the first three leeters of a word and capitalize them to add to numbers to create a part number. Thanks in advance.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I capitalize and parse in the same formula?
=UPPER(LEFT(A1,3))
-- Regards, Peo Sjoblom (No private emails please) "blondegreenjeans" wrote in message ... I need to write a formula that does 2 functions, LEFTand UPPER. Is this possible? I need to "grab" the first three leeters of a word and capitalize them to add to numbers to create a part number. Thanks in advance.... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I capitalize and parse in the same formula?
=upper(left(a1,3))&"1234"
or maybe: =upper(left(a1,3))&text(b1,"0000") if b1 contains a number. blondegreenjeans wrote: I need to write a formula that does 2 functions, LEFTand UPPER. Is this possible? I need to "grab" the first three leeters of a word and capitalize them to add to numbers to create a part number. Thanks in advance.... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|