If you want to get rid of all hyperlinks in an Excel sheet, there are a few ways you can do this. One way is to use the Find and Replace feature. Go to the Home tab, click on Find & Select in the Editing group, and then click on Replace. In the Find what field, type in "^p" (without the quotation marks) and leave the Replace with field blank. Then click on the Replace All button. This will remove all hyperlinks from your sheet.
Another way to remove hyperlinks is to use a macro. The following macro will remove all hyperlinks from your active sheet:
Sub RemoveHyperlinks()
Dim i As Long
For i = ActiveSheet.Hyperlinks.Count To 1 Step -1
ActiveSheet.Hyperlinks(i).Delete
Next i
End Sub
To use this macro, open the Visual Basic Editor (press Alt+F11), insert a new module (Insert > Module), and paste the code into the module. Then close the Visual Basic Editor and run the macro by pressing Alt+F8 and selecting RemoveHyperlinks from the list of macros.