Turn column of text email address into hyperlinks

I have an excel 2007 spreadsheet with various data in it. One column of the spreadsheet conatains hundreds of email addresses. Some of the email addresses are hyperlinks (if you click on the address, it will open outlook and create a new email), but many of the addresses are not hyperlinks. Is there a way to make all of the email addresses in that column hyperlinks?

Highlight the cells you want to add the hyperlinks - run the following macro.

Please Login or Register  to view this content.