Extracting a name from URL

Copper Contributor

Hi I am trying to just get the link name, for example from the link below, I just want to extact 

home-of electric

Therefore just the text after /web/en/ and before the HTML.

https://www.audi.co.za/za/web/en/home-of-electric.html

Your assistance will be much appreciated

Thanks

1 Reply

@RikavanVuuren 

One way to do it:

=TEXTBEFORE(TEXTAFTER(A1,"/",6),".")