Hi everyone, new user here. I have a column full of link addresses, probably 500-600. The problem I’m having is how to setup that entire column so I can use the Ctrl-Click for each link where it opens that page in my browser… As it stands, all I can do now is just edit each cell one-by-one. Is there anyway I can do a global selection for this ? Thank you!
in next column (say B1) put =HYPERLINK(A1)
and many more tricks of sort : Automatically recognize all URLs in Calc - #6 by Anchoa
Excellent thank you. It’s strange… when you edit a single cell and insert the hyperlink, it doesn’t show it in that cell as a formula… just see the text. Whatever the case, problem solved 