Ask Your Question

Calc: Convert text to link [closed]

asked 2012-10-08 11:25:30 +0100

EzMe gravatar image

updated 2013-06-15 00:41:59 +0100

manj_k gravatar image

I guess this is a simple question but I cannot seem to fix it. I've got a Calc sheet with about 5000 lines which have all lines like cell A1: W:\qt-reports\qt10-418.ods

I'd like to make these clickable links but I cannot seem to find how. I allready made collum which looks like: =HYPERLINK($A1)

but that sollution does not suite me very well sinds we got now two collums. I just like to make collum A1 clickable without manually change all the 5000 lines. Would that be possible?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 15:39:47.203028

2 Answers

Sort by » oldest newest most voted

answered 2012-10-08 11:47:37 +0100

JohnSUN gravatar image

Try to find the right settings to command Search & Replace


edit flag offensive delete link more


In English =HYPERLINK("&1";"&1") In Portuguese =HIPERLINK("&1";"&1")

sanlemos gravatar imagesanlemos ( 2019-08-26 05:23:28 +0100 )edit

answered 2012-10-08 13:18:20 +0100

EzMe gravatar image

Thanks! That worked out nicely! :)

edit flag offensive delete link more


For me it worked only after removing "1": =HYPERLINK("&")

Gerrit Griebel gravatar imageGerrit Griebel ( 2016-11-21 11:32:51 +0100 )edit

Question Tools


Asked: 2012-10-08 11:25:30 +0100

Seen: 13,121 times

Last updated: Oct 08 '12