b6f95285_r_not___videos____Office_Blogs__Question
[Answer] Excel 2010 has two new menu items that can help you remove multiple hyperlinks at once: Remove Hyperlinks (note the plural!) and Clear Hyperlinks. These commands allow you to instantly clean up a whole list of links. If you’re using an ancient version of Excel, Bill shows you how to use a macro instead. Bonus: Learn how to stop Excel from automatically creating hyperlinks as you type. [See for yourself] Video: Get rid of hyperlinks [Question] 
How do I remove one or more hyperlinks? How do I turn off the automatic creation of hyperlinks?
Hyperlinks in Excel: Hot or not? (videos) - Office Blogs
Question