Ask Your Question
0

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
1

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

JohnSUN gravatar image

Try to find the right settings to command Search & Replace

Create HYPERLINK

edit flag offensive delete link more

Comments

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

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

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

EzMe gravatar image

Thanks! That worked out nicely! :)

edit flag offensive delete link more

Comments

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

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

Question Tools

Stats

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

Seen: 13,121 times

Last updated: Oct 08 '12