Excel Hyperlink question

[sterjohn]

I wonder if someone could please help?
I have a column of email addresses in plain text in excel 2016 that I need to convert to clickable email links?
Is there a way that I can change all the email addresses to link at the same time?
Any help would be appreciated.
Kind regards,
John.S
Australia

 

[sterjohn]

Awesome Col, thanks!
Exactly what I was after..
I'm sure you find it easy and I appreciate your taking time to help out a novice.
All the best,
John.S

 

[Col Delane]

Thanks, once again, for the feedback John.

I was in your position 20 years ago when I first learned about MrExcel and this forum, and it has been a great FREE resource to me ever since in my search for solutions to Excel problems. I doubt I'll ever be an MVP but I love playing with Excel and do like puzzles, so when I get free time I try to peruse the older "Zero Reply Posts" to see if I can "give something back" by helping out guys like you. (I'm not one to brag but I've answered about 40 posts in the last month - an all time record for me!! )

Good luck - I'll keep a look out for you handle on future posts.