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.
Subodh_Tiwari_sktneer - Please see the attached file for reference.
Attached formula (added in J2:K3) may suffice, provided raw data field will always include "Area-", "DC-" & "RCA-" in that order...
It's basically a MID formula where the start position and character counts are based on the above mentioned constants, in the string.
Hope this helps.