+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Excel question: formatting email addresses (/showthread.php?tid=123147)
Excel question: formatting email addresses - john-o - 09-05-2011
I'm looking at a spreadsheet that was sent from a client. There's a column with email addresses that are in plain text, and it seems like there should be a command somewhere that could convert them all to 'live' clickable links in one fell swoop. I've been unable to locate any such command, so it appears to not be possible. Is that true?
Seems like such a pain to have to do it one cell at a time!
Excel from Office 2011 on a Mac Pro running 10.6.8
Re: Excel question: formatting email addresses - olnacl - 09-05-2011
A quick Google found these:
http://www.mrexcel.com/forum/showthread.php?t=72516
http://www.excelforum.com/excel-general/666850-turn-column-of-text-email-address-into-hyperlinks.html
Hope that helps.
Re: Excel question: formatting email addresses - john-o - 09-05-2011
Thanks. Guess I shoulda googled it myself... I just thought there'd be an Excel expert here who could help.
Re: Excel question: formatting email addresses - cbelt3 - 09-05-2011
john-o.. sorry. This "Excel Guru" avoids clickable links in Excel files like the plague, and strongly recommends against it.
We have a department that uses an Excel front end as sort of a complex document management system. It makes me want to cry every time they screw it up, I keep trying to push them to something more robust.... the last time they broke it someone 'accidentally renamed' a directory, and the whole thing went pear-shaped.
Re: Excel question: formatting email addresses - john-o - 09-06-2011
Thanks for the heads-up cbelt! After dinking around with the macro a bit, I decided it wasn't worth the trouble. No clickable-links it is!!