Just select the cells and run this macro

Sub DeleteHyperlinksFromSelection()
Selection.Hyperlinks.Delete
End Sub

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup