Does anyone have a macro that can turn multiple cells in URL format (about 50,000, in my case) into clickable hyperlinks? I had one but lost it in an upgrade.
Never mind. I found the answer:
Do ^A or select the portion of the spreadsheet you want to convert.
Do ^H.
Set “regular expressions”.
in the “Find” box put: (http://.*)
In the “Replace” box, put: =hyperlink("&")
Hit “Replace all”.
Hit “Close”
Make these simple steps into a macro.
–Sarge