Microsoft Office

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.