Text plain to hyperlink in Calc

[Arconada28]

Hi all,

I have imported a column from a CSV to an ODS file with links (local files, not url) to photos like this:

file:///usr/people/myuser/file1.jpg

file:///usr/people/myuser/file2.jpg
…

By now they are text plain and I’d like to convert them to clickable hyperlinks. If I rewrite manually the routes, it works, but I have hundreds of files and I need to do it in an automatic way.

Any suggestions? Many thanks in advance!

[jfn]

Hello!

did you check the Ask-ed questions beforehand?

Also, querying my preferred search engine: “calc automatic convert text to hyperlink”

I found this question (and response Calc: Convert text to link

Does it fit your needs?