At 08:18 17/08/2020 -0400, David Stuhr wrote:
I have an OpenOffice spreadsheet that has over a thousand hyperlinks
to an external www website. The information in each hyperlinked cell
is the URL and descriptive text. From a search of the web it appears
that Excel has a "get URL" function but a search of OpenOffice help
did not return a similar function.
Is there a method/way of getting the URL in a cell that contains a
hyperlink and putting it in another? I want to do this to identify
duplicate URL references.
See
https://superuser.com/questions/315752/separating-text-and-links-from-a-hyperlink-in-openoffice
- which includes a function CELL_URL() which appears to provide what you need.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org