extract info from a link

[vanthetsar]

Hi all,

I have a file with many links and i need a dynamic formula for getting the last part of the link (was using right, but the string length might vary) ex:

https://www.zoro.com/sk-professional...36mm-hex-48236/i/G4426721/ i would need the (/i/G1539781/ ) as an outcome on a different excel file, the problem is that sometimes the lenght of that part might either change or start with a different letter for example it might be /g/G1556639781/

Thanks in advance to anyone that can help!

[oeldere]

What is the indicator (the 4th / in the link)?

[Shareez Saleem]

=mid(a1,find("&&",substitute(a1,"/","&&",4),1),99)

[vanthetsar]

What is the indicator (the 4th / in the link)?

Yes the 4th

[vanthetsar]

=mid(a1,find("&&",substitute(a1,"/","&&",4),1),99)

thanks this work !!