Remove all hyperlinks from a spreadsheet

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.

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

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

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.