Folks,
I have a text description in a cell which will sometime have the first 4
characters as uppercase:

i.e.

XBDP BDA OTHER: BOARDROOM PROD 08425360I

I want to be able to evaluate XBDP and return with the text "IA Code". I
thought I could do a left function combination that is evaluating an
uppercase string saying: if(left(A1,4) is uppercase, then type in the text
"IA Code" else type in the code "Other". I am trying to avoid doing a text
to column excel function.

I'll appreciate any help on this. Thank you.

Regards,
Shams.