I am trying to isolate the center word in a text string such as CREW_WHITE_TJMAX I have tried using LEFT function and RIGHT function but can't seem to isolate it considering other text strings I am trying to isolate have different amounts of characters (EX:CREW_BLUE_TJMAX or CREW_RED_TJMAX)
any ideas?
There are a few ways... one approach:
B1: =TRIM(MID(SUBSTITUTE(A1,"_",REPT(" ",100)),100,100))
Where A1 contains string of interest
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
mburgess,
Please read the forum rules about thread titles before posting again.
Thanks.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks