Home / ubuntu / Questions / 440508
Accepted
David Oneill
Asked: 2014-03-29 13:28:40 +0800 CST

Remove all hyperlinks from a spreadsheet

  • 772

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.

libreoffice

5 Answers

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

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

    That's all.

    • 29
  2. Best Answer

    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".

    • 6

  3. 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

    • 2

  4. In LibreOffice Calc (Version: 4.3.7.2; Build ID: 4.3.7.2-2.el6_9.2):

    1. Click Edit => Links...
    2. Click 'Break Link' and 'Yes' on every line item
    3. Click Close
    • 1

  5. In LibreOffice Calc, Go to the menu Header on top-->from the dropdown selection of paste button select unformatted text and you're done!

    • 1