What I need to do:
Convert hyperlinks and page titles list to clickable page titles only then export to HTML file
They are currently in a OpenOffice .csv calc file as:
Column A with hyperlink
Column B with page title
There are hundreds of rows.
The hyperlinks are formatted as --- http:// whatever.com , some with trailing /
Have done some searches for this solution but none seem to work so far.
Or perhaps copy the rows and columns to a text file and try to accomplish the same thing in a different way?
Any example suggestions would be greatly appreciated!