תאריך פרסום: Oct 20, 2014 2:31:55 PM

Get the URL from an Excel Hyperlink 

By Israel Sellem, on October 10th, 2014

Export contacts from Walla Mail account

You have to copy the list of contacts

If you paste hyperlinks as HTML in a Blank workbook, what you're left with is the "Friendly Name." That's the text you can see in the cell with the hyperlink, like  in the screen shot below.

Instead of the Friendly Name, you might want to extract the ScreenTip hyperlink's location. There's no built-in function for that in Excel, but you can create your own, with a bit of VBA.

Use Alt+F11 to open Microsoft VBA

Copy the GETScreenTip code, shown below, into a regular module in your workbook.

Goto Insert module and paste

Then, you can use the  GETScreenTip function in that workbook, just like any other Excel function. For example, to find the ScreenTip address for a hyperlink in cell B2, use this formula: = GETScreenTip(B2)

To extract the Friendly Name with the Hyperlink export the file to Comma separated values (csv).

Learn More About Hyperlinks

To learn more about adding and removing Hyperlinks, visit the Excel Hyperlinks and Hyperlink Function page on the Contextures website. There are written instructions, and videos, like this one.

Get the url from an excel hyperlink 

From http://blog.contextures.com