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
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.
===Edit===
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.