Extract Multiple URLs from the hyperlink in Excel
When we are having whole series with hyperlinked URLs, from which we want to extract the corresponding underlying URLs. This will help to extract actual addresses from multiple hyperlinks. Extract URL one by one from Hyperlinks Extract actual addresses from hyperlinks with Edit Hyperlink feature. When you are having limited Hyperlinks in excel, then you can simple use Edit Hyperlink function. With this method, you can extract only one hyperlink address each time. You can extract the linked URL using Edit Hyperlink function. Right click on the cell of underlying text and click Edit Hyperlink as below. 1. Right click on the cell of underlying text and click Edit Hyperlink as below 2. Edit Hyperlink dialog box will be appeared . Select and copy (Ctrl+C) the entire URL from the Address field. 3. Close the dialog box and paste it into another cell Extract actual addresses from set of hyperlinks with VBA code Following VBA code method will help