> On May 26, 2021, at 16:58, David Stuhr <david.st...@verizon.net.INVALID>
> 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 should work:
- export as CSV [or TSV]
- write a program to find the URLs and rebuild the CSV with the new cell
- open in calc and save as .calc
—
jt - j...@jt-mj.net
Do unto those downstream as you would have those upstream do unto you. -
Wendell Berry
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
