Posts: 2,569
Threads: 443
Joined: Oct 2021
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
Posts: 5,338
Threads: 670
Joined: Dec 2021
Posts: 2,569
Threads: 443
Joined: Oct 2021
Thanks. Guess I shoulda googled it myself... I just thought there'd be an Excel expert here who could help.
Posts: 57,782
Threads: 5,856
Joined: May 2025
Reputation:
3
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.
Posts: 2,569
Threads: 443
Joined: Oct 2021
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!!
