Forum Discussion

resham1985's avatar
resham1985
Former Employee
Jul 02, 2020
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 another column 

 

excel
Formulas and Functions

9 Replies

  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Silver Contributor
    Jul 02, 2020

    resham1985 

     

    Please populate the few possible entries of raw data in column A and mock up the desired output in column B and then upload the Excel file here so that it would be easier for us to see the pattern and expected output.

      • Charla74's avatar
        Charla74
        Iron Contributor
        Jul 02, 2020

        resham1985 

         

        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.

Resources