> On May 26, 2021, at 16:58, David Stuhr <[email protected]>
> 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 - [email protected]
Do unto those downstream as you would have those upstream do unto you. -
Wendell Berry
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
