Ask Your Question

Editing Hyperlinks in Calc [closed]

asked 2016-10-13 09:56:09 +0100

Alex H gravatar image

I use my PC as a media centre. I have many films and TV programmes (2000+) on 3 large disks. I use Calc to list the files and a hyperlink to play the video file.

If I wish to move files about, I have to recreate the hyperlink.

Is there any way to do this in bulk or do I have to do them one at a time?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex H
close date 2016-10-14 08:46:45.507387

2 Answers

Sort by » oldest newest most voted

answered 2016-10-13 17:01:05 +0100

pierre-yves samyn gravatar image


With hyperlinks in Col A (e.g.) A2:A10,

  • enter in (e.g.) Col B: =A2
  • copy down the formula
  • select B2:B10 then DataCalculateFormula to Value (may be in Tools menu for older versions)

Now you have a col with hyperlinks as text, so you can use Find & Replace to update the links. You also can then use Find & Replace to convert these texts to hyperlinks:

Select B2:B10 then Find & Replace:

  • Find: .*
  • Replace: =HYPERLINK("&")
  • Other options: tick Current selection only and Regular expressions
  • Replace All


edit flag offensive delete link more


That works perfectly - Thank You Very Much!

Alex H gravatar imageAlex H ( 2016-10-14 08:45:54 +0100 )edit

answered 2016-10-13 19:37:21 +0100

Lupp gravatar image

updated 2016-10-13 19:38:06 +0100

Did you look for something similar to what is demonstrated here?
(To get it work you must input folders and files actually existing on your system, of course.)

You may hide columns B through D as long as you don't need to edit the contents.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-10-13 09:56:09 +0100

Seen: 692 times

Last updated: Oct 13 '16