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.... |
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.... |
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 |
All times are GMT +1. The time now is 02:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com