Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching Uppercase characters
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching Uppercase characters
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching Uppercase characters
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching Uppercase characters
Try: =IF(AND(EXACT(LEFT(A1,4),UPPER(LEFT(A1,4))),MID(A1 ,5,1)=" "),"IA Code","Other") or =IF(AND(EXACT(LEFT(A1,4),UPPER(LEFT(A1,4))),MID(A1 ,5,1)=" "),LEFT(A1,4),"Other") -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PARTIAL TEXT MATCH SEARCHING FOR THE FIRST 6 CHARACTERS? | Excel Worksheet Functions | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
Uppercase help | Excel Discussion (Misc queries) | |||
Uppercase | Excel Worksheet Functions | |||
Formulas dealing with searching for characters | Excel Worksheet Functions |