Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I copy/paste from a website into gnumeric (or LibreOffice Calc) from a website, I want to be able to quickly strip away all hyperlinks and leave just text.

How do I do this?

Solutions in either program will be accepted, although gnumeric is preferred.

share|improve this question
up vote 3 down vote accepted

In Gnuneric: Menu "Edit" -> "Clear..." -> "Formats and Hyperlinks":

enter image description here

Another way is selecting the cells to edit, right-click and select "Remove [n] Hyperlinks".

share|improve this answer

In LibreOffice Calc (Version:; Build ID: 410m0(Build:2):

  • select the cells containing hyperlinks
  • Click on Format > Clear Direct Formatting (or just press Ctrl+M)

That's all.

share|improve this answer
This works for LibreOffice - thanks! – David Oneill Mar 29 '14 at 22:18

When you copy the info, and you're ready to paste, click on Edit --> Paste Special --> Unformattted text, and once the new window opens, review the info,choose your text import settings, and then click OK. See images below.

The text example in the last image, are links from a website, and it got pasted as text, and not hyperlinks.

enter image description here

enter image description here

enter image description here

share|improve this answer
Sadly, this is only intermittently available - usually paste special is greyed out. – David Oneill Mar 29 '14 at 22:18

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.