Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a list of bookmarks which is converted into an OpenOffice spreadsheet. Now I want to separate the linkĀ URL and its text separately into two columns.

Is there any method to achieve this?

share|improve this question
Giving us an example of how this spreadsheet looks like would really really help to solve your problem. –  slhck Jul 27 '11 at 13:21
The spreadsheet looks something like this: Hyperlink Link Text Link URL Ubuntu Ubuntu ubuntulinux.org Ubuntu Wiki (community-edited website) as for the 1st one: the url link is attached with word ubuntu. Now ubuntu is separated from its link. I want to separate links and its text. Make a Support Request to the Ubuntu Community Debian (Ubuntu is based on Debi an) Ubuntu One - The personal cloud that brings your digital life together –  Kush Aug 2 '11 at 13:36
Please use the edit function to update your question -- your comment is not readable at all. –  slhck Aug 2 '11 at 15:11

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.