How to Extract URLs with Excel
Sometimes, you need to extract URLs from links you get in excel.
I have the perfect VBA function that can help you out with this.
In Excel for Windows or Mac, you can create a custom VBA function, as follows:
- Press ALT+F11 to activate the Visual Basic Editor
- Select Insert > Module
- Copy the code listed below into the module
Function GetURL(cell As Range) As String
GetURL = cell.Hyperlinks(1).Address
End Function
- Switch back to Excel. You can close the window.
- With a hyperlink in A1, the formula "=GetURL(A1)" will return the URL of the hyperlink in the A1 cell.
- Save the workbook as macro-enabled workbook (*.xlsm extension).
- Make sure that you allow macros when you open the workbook. If the pop up window doesn't work or the macro doesn't work, check and make sure you allow macros in Excel.
Go to File -> Options -> Trust Center -> Macro Settings
