Can anyone explain this formula:=MID([@URL],SEARCH("/",[@URL],8),SEARCH("-t*.html",[@URL])-SEARCH("/",[@URL],8))

[Pingbat]

Hi from York UK...

This formula:

=MID([@URL],SEARCH("/",[@URL],8),SEARCH("-t*.html",[@URL])-SEARCH("/",[@URL],8))

does exactly what i want but i just copied it off the internet. The results of the formula are below:

https://drive.google.com/file/d/1fthxBLgQYJOZmEiP9LJG2QsrODe013VN/view?usp=sharing

But why the @URL elements in the formula? Bit confused

Thanks in advance,
David

 

[Fluff]

It's because the formula is in a table & you are looking at a cell in the URL column.

 

[Pingbat]

Ah i see, is the alternative to [@URL] a cell reference as in:
=MID([A14],SEARCH("/",[A14],8),SEARCH("-t*.html",[A14])-SEARCH("/",[A14],8))

Thanks in advance,
David

 

[Fluff]

That's right

 

[Pingbat]

Bravissimo it works e.g.=MID(A15,SEARCH("/",A15,8),SEARCH("-t*.html",A15)-SEARCH("/",A15,8))

Massive thank you to @Fluff