> On May 26, 2021, at 16:58, David Stuhr
> wrote:
>
> I have an OpenOffice Calc (spreadsheet) that has over a thousand Hyperlinks
> and I would like to create a user defined function which would extract the
> URL from the Hyperlink and put it in a separate cell.
If all else fails this
you can write user defined functions it's very easy. The easiest way is to pass
the value of a cell and then just return a string or whatever you want. I don't
remember what happens when you pass the cell value like that if you are parsing
out text and pulling out a URL property it's probably
Hello,
I have an OpenOffice Calc (spreadsheet) that has over a thousand
Hyperlinks and I would like to create a user defined function which
would extract the URL from the Hyperlink and put it in a separate cell.
I found an Excel example on the web which I pasted in below.
Function
