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.


Filed under: ASAP Utilities on October 10th, 2007 by Bastien |

One Response to “Video: How to extract hyperlinks in Excel with ASAP Utilities”

  1. Ray Shan, on October 11th, 2007 at 2:56 am Said:

    Love the new screencasts and your tools! Keep them coming please!

    R

Leave a Reply

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

« Video: How to sort by color in Excel with ASAP Utilities
Video: How delete leading, trailing and excessive spaces in Excel with ASAP Utilities »