There are numerous occasions when we want to extract file name from given URL’S in excel. In my case this situation arises when we are migrating data and we have to prepare reports for the same. There might be various ways to extract files names from URL’s in excel but I use simple find and replace functionality to accomplish this task.
Below are the steps to extract filenames from given URL in Excel:
- Open the excel with all URL’S from where we have to extract file name.
- Create a separate column with “File Name”.
- Select the column with the file name URL’s.
- Copy the values from the “URL’s” Column and paste them on newly created “File Name” column.
- Now Select the column “File Name” and hit “Ctrl + F” to get “Find and Replace” dialogue box.
- Navigate to Replace Tab.
- In “Find What” type – “*/” without quotes (“”).
- Leave the “Replace With” field blank.
- Click on “Replace All” button.
- A confirmation box will popup with information on how many records have been replaced.
- Close the “Find and Replace Dialogue” box.
- You are done.
This is the easiest way I have used to extract file name from URL or file path. Share with us if you are using other easiest way to do the same. 🙂
Header Image Credit: stocksnap.io
