When you are working with lists of URLs in Excel, sometimes you need to have the file name or the last item in the URL. The code below should work for most versions of Excel.
Replace A1 with the column and row that has the URL.
VB
=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",255)),255))All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.