function help

[matts29]

Hi

I have a number of random locations in the below column. What can i use to get the red higlighted text into a new column please? I am thinking is there a way to write to extract only the text between the 5th and 6th '/'? Is there a way to use the Mid function for this please? So in my new Column I would have 'Finance and Procurement',IT and Maint etc..

Column A

/sites/msteams_bgf354-BasilCorporateAwordversions/Shared Documents/Corporate A (word)/Finance and Procurement/UKLP Checked

/sites/msteams_bgf354-BasilCorporateAwordversions/Shared Documents/Corporate A (word)/IT and Maint/UKLP Checked

[NishPatel · Accepted solution]

Go to Power Query and Select the column that you need to extract the data. From the home tab, select split column --> By delimiter and enter below information and it will split data into columns with the data in between each / (slashes) 

[matts29]

Thanks Nish, thats helped greatly 🙂