View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
blondegreenjeans
 
Posts: n/a
Default 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....