FAQ: How can I remove the hyperlinks hidden in my spreadsheet?
There can be many of these links in a sheet and it can be quite annoying or even impossible to find them all because you have to go cell by cell.
So by using a small macro, you can easily delete them all in bulk.
Do do this, enter macro mode by pressing Alt+F8.
type any name like for a macro and press create
Then paste the following code in the macro created.
Dim WS As Worksheet
Set WS = ActiveSheet
Then go to the spreadsheet and press ALT-F8 again.
Once you run the macro all the links will disappear. The text only will remain.