Split text by text

[raikks]

I would like to split the text below and the delimeter should be "-vs" & "h2h"?
Here is the link - beijing-guoan-fc-vs-shanghai-sipg-fc-h2h-stats#539665

Can anyone help?

 

[Peter_SSs]

I think it works with Power Query too

I'm sure it does.

 

[sandy666]

Where do i input that code (i'm not familiar with Power Query)?

this shortcut should work: Alt A PN O Q
it will open PQ editor then open Advanced Editor and replace code there with copied from the post#2

 

[sandy666]

note. source data should be an Excel Table (Ctrl T)
adjust name of the table in the code to yours (now it is Table1)

 

[raikks]

Thanks for the followup, sandy666.
Very quick & easy - great stuff.
Cheers!

 

[sandy666]

You are welcome
Thanks for the feedback
Have a nice day