Extract Web Address from Hyperlinks in Excel

Tutorial on How to Create an Excel Function that will let you quickly pull out the web addresses of hyperlinked cells in MS Excel. http://goodwebz.com/website-migration/extract-web-addresses-from-excel-hyperlinks/
MS Excel is a great help in organizing website data for Website Migration and SEO purposes.

This is one trick that anyone who has had to deal with hyperlinked cells wishes that Excel would do right out of the box.

Excel hyperlinks can point to:

• Other cells on the spreadsheet
• URL's on the internet(aka website pages).

But copying all the hyperlinks into their own column 1 at a time takes too long if you have a long list to extract. What if you have a few hundred or a few thousand. It can take hours or days to extract a few thousand web page links and pull out the hyperlinks into a separate column.

There is a much better way that you can get the job done right and shave hours off your work.

Have an Excel spreadsheet with hundreds or thousands of cells with hyperlinks that need URL information to be displayed in a separate column? No problem. The URL extraction will take just seconds, making you the Excel guru of the office(please accept my apologies in advance...)

This is the perfect function any time you have a massive amount of hyperlinked data in an Excel spreadsheet that you need to pull out such as a website migration or an SEO project.