Hello, hope you can help me.
Did this some time ago and for the life of me I cant remember how.
Excel 2010

I have been given a plain text list of hundreds of email addresses but need to make them active so they open Outlook when clicked.

I know how to use autocorrect so they are active when typed in one by one but not how to convert them from a plain text list.
Many thanks