I want to lookup and use/extract just the .jpg name from this cell, into a new cell example 100012.jpg and 100015w.jpg
the urls vary
http://www.moon.co.uk/rsc/img/100/100012.jpg
http://www.sky.co.uk/rsc/img/200/100015w.jpg
how do i do it?
I want to lookup and use/extract just the .jpg name from this cell, into a new cell example 100012.jpg and 100015w.jpg
the urls vary
http://www.moon.co.uk/rsc/img/100/100012.jpg
http://www.sky.co.uk/rsc/img/200/100015w.jpg
how do i do it?
Re: Extract File Name From Url
If such a url is in cell A1 for example, then to return its file name you can use this formula in cell B1, thanks Hotpepper.
=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",99)),99))
Re: Extract File Name From Url
Thank you.
Don’t have an account yet? Register yourself now and be a part of our community!