How to quickly remove all hyperlinks or a selection of hyperlinks from Excel.
This removes the link itself and any associated formatting but keeps the visible text in place.
Remove All Hyperlinks from a Worksheet at Once
This is a simple little trick that will save you a lot of time when you have to clean-up a worksheet.
Download the sample worksheet attached to this tutorial to try this out in Excel.