Strip Filename from a websit url

Hi

I have a long list of URL's of images on my website that I want to import into my database. I have downloaded the list of images into excel and they appear as follows:-

http://www.mywebsite.com/images/image1.jpg
http://www.mywebsite.com/images/image-two.jpg
http://www.mywebsite.com/images/imagethree.jpg
http://www.mywebsite.com/images/image4.jpg

I want to use excel to prepare a csv file to import into my databse but I only want the image name rather than the whole URL... thus I want a formula/macro which would return:-

image1.jpg
image-two.jpg
imagethree.jpg
image4.jpg

I have over 2000 records to import!
Can this be done somehow?

Thanks for the help!!
sagarhAsked:
Who is Participating?
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
=RIGHT(A1,LEN(A1)-FIND("|",SUBSTITUTE(A1,"/","|",LEN(A1)-LEN(SUBSTITUTE(A1,"/","")))))

Kevin
0
 
sagarhAuthor Commented:
Thanks! works perfectly.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.