Hello,

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.

Thank you for your assistance.

Reply via email to