HOW TO REMOVE A HYPERLINK TO AN EMAIL ADDRESS - Microsoft Office 2016: The Complete Guide (2015) 

Microsoft Office 2016: The Complete Guide (2015)

HOW TO REMOVE A HYPERLINK TO AN EMAIL ADDRESS

Email addresses that have been converted to hyperlinks can be deactivated, similarly to general hyperlinks

Go to the worksheet and select the cell which contains the hyperlink to be deactivated.

TIP   Excel also provides the option to use objects, such as pictures or an element to represent a hyperlink.

Select Remove Hyperlink after you have right-clicked on the cell.