I received a spreadsheet with a list of addresses setup so you can click the name in the cell and it would open. I wanted to export the actual url which is
inside the cell.
You can do this with a function. Open the VBA editor with Fn/Option F11 on the Mac. Then
Open Modules and insert a new module with a name of your choosing.
Paste in the following function, save and exit the VBA editor
Function GetCellURL(cell As Range) As String On Error Resume Next GetCellURL = cell.Hyperlinks(1).Address End Function
Then visit your spreadsheet and start a new column and use your function to reference a cell that has a hyperlink.