hyperlinkopenoffice.orgspreadsheet

Extract hyperlink from Open Office Calc Sheet

I have an Open Office Calc Sheet with a column full of data that has hyperlinks. I wish to trasnfer the hyperlinks to another column. How do I extract them?

Thanks.,.

Solution

  • It seems one must write a custom function for it.