Video: How to extract hyperlinks in Excel with ASAP Utilities

The following video will demonstrate you extract hyperlinks from cells in Excel by using ASAP Utilities.

The example in the video show a list of websites that I copied from my links-page. There is no easy way in Excel itself to get the hyperlinks from the cells. That's why I built such a functionality into ASAP Utilities.

Extract hyperlinks

First select the cells and then in the Excel menu choose ASAP Utilities » Web » Extract hyperlinks...

Besides this utility, you can also use the worksheet function =ASAPGetHyperlink() to retreive the link addresses.

Note: This old video is no longer available and will in 2021 be replaced with a new version in a modern version of Excel.