Forum Discussion
Solved
Find a word between words in excel
Escalation : RES26181649 : Urgent Help Needed- I need RES26181649 in one seperate column
Area-US, DC-Bangalore, RCA-Process-CSPO-TicketPrioritization- I need Bangalore in one column and US in anot...
Subodh_Tiwari_sktneer - Please see the attached file for reference.
resham1985 Here is the formula I used, which assumes the outcome you want follows "SC - " and is 3 characters or 2 characters followed by a ";". In you sample I assume and hope that your expected outcome on line 5 is a typo.
=SUBSTITUTE(MID($A2,SEARCH("SC -",$A2)+5,3),";","")
Hope is works and make sure to like the helpful posts and mark best solution to 'close' the thread.