Thank you very much for your help! I realized one more wrinkle in the text
after I sent out my message:
XBDP BDA OTHER: BOARDROOM PROD 08425360I
The good news about this text is that the variant XBDP will always be
followed by a space. So, can I add the space as well to my parameters so
that if the left(a1, 4) is uppercase as well has a space immediately
following it then return left(A1,4).
Thank you.
Regards,
Shams
"NBVC" wrote:
Try
=IF(EXACT(LEFT(A1,4),UPPER(LEFT(A1,4))),"IA Code","")
--
NBVC
Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116170