Episode # 664 - Extracting Links

Have a bunch of hyperlinks in Excel? Extract the URL from each link to a new column.

Sponsored by

Check out this book for more tips
similar to this lesson!

Thursday, January 10, 2008

When you paste web data to Excel, many hyperlinks are created. In today's episode, I create a couple of lines of code to extract all of the links and write them to a new column in Excel. Episode 664 also shows you how to use the Watch Window to discover property names. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 4 minutes to learn this lesson now with our free video!

Watch Video

Click Play icon to play the video. You might first need to click on the Video to activate Flash player.

Tags/Keywords for this video: VBA, Links

Episode # 664 - Extracting Links

Have a bunch of hyperlinks in Excel? Extract the URL from each link to a new column.

More Excel Video Lessons