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.