Question

6

Remove all hyperlinks from a spreadsheet

rated 0 times [ 6] [ 0] / answers: 1 / hits: 33090 / 2 Years ago, mon, march 14, 2022, 5:21:50

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.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

skaing

Add To Favorites

Follow

Total Points: 462

Total Questions: 124

Total Answers: 113

Location: Nauru

Member since Thu, Feb 2, 2023

1 Year ago

answered 2 Years ago ntlesslving · Accepted 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".