Ask Your Question

macro to create multiple hyperlinks in calc - urgent

asked 2019-07-11 18:32:24 +0200

sarge gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-07-11 19:05:59 +0200

sarge gravatar image

updated 2019-07-11 19:40:38 +0200

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.


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-11 18:32:24 +0200

Seen: 23 times

Last updated: Jul 11