Ask Your Question

How separate URLs from text in spreadsheet to own column?

asked 2019-06-04 15:04:02 +0100

kkrabat gravatar image

updated 2019-06-04 15:12:16 +0100

well, basically what the question says:

I use spreadsheet as a database - unprofessional, but Ive always done it, but now this content has grown to 2000 entry lines A-L. And now I need a list of all of the embedded URLs separately, on their own

Inversely, how does one join a column of URLs and a column of text to make clickable text?

thank you for your time. kk

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-06-04 16:05:58 +0100

Lupp gravatar image

updated 2019-06-04 16:55:46 +0100

Concerning the "inversely": There is the standard function HYPERLINK() which can create a clickable area if given an URL and the anchor text as arguments. If the anchor text is omitted the URL itself will be used in this role. However, this way you don't get actual linked text. In Calc cells links are implemented differently than in Writer texts. You can create and insert them by user code, but you need to learn.

Concerning the first part of the request:
I don't know how to do so without relying on user code. Fortunately you can find such code here. There is also this example document.

I missed to mention that the demo uses the REGEX() function which only is implemented for LibO V 6.2 +.
(Big new advantage of LibO over MS O, imo.) The user function contained in the demo also runs in old versons and in AOO.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-04 15:04:02 +0100

Seen: 64 times

Last updated: Jun 04 '19