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....
|