How do I capitalize and parse in the same formula?

  • Thread starter blondegreenjeans
  • Start date
B

blondegreenjeans

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

Dave Peterson

=upper(left(a1,3))&"1234"
or maybe:
=upper(left(a1,3))&text(b1,"0000")

if b1 contains a number.
 
Top