How do you extract a hyperlink from a cell?

Running LO 7.5 on Mac Ventura.
I have a spreadsheet with a column of hyperlinks, i.e. the result of using Insert–>Hyperlink. When I save as CSV, the CSV has only the “text” of the hyperlink, the “URL” is gone.
How can I get the URL into the CSV? I was thinking maybe a calculation in another column to display the URL, but I can’t find a function for that.

[Calc, Basic] Introspective cell functions

1 Like

Note: a Cell can contain more than one Hyperlinks = more than one URL’s. Villeroy’s macro function can handle this state.