Convert plain text email addys in Excel 2010

[bazwillrun]

For the life of me I cant remember how I did this.
Excel 2010, I have a list of hundreds of plain text email addresses, I cant remember how I converted them to active addresses so that when individually clicked on they open up Outlook 2010.

I can change them one by one by just adding a space at the end of each text address or by making sure autocorrect is on for typing them in one by one, or using the Hyperlink function.

But I want to select the whole column and convert them in one go, I seem to recall this was very easy when I last did it but just cant remember how I did it.

so far my google search has come up with nothing

[ChuckFickens]

Only way is going to be either a macro or a VB script.

I've just checked and this macro works and does what you want.

http://www.mcgimpsey....onverttomaillink.html

[bazwillrun]

Thanks.
I've written all sorts of VB scripts for this particular sheet and there isnt one for converting a whole column of email addys, I'm sure I did it with a couple of clicks in the past.

I can use the linked script (need to take out some of the code thats not needed) until i figure out how I did it