See

http://www.mcgimpsey.com/excel/nohyperlinks.html


In article ,
"Jumping Rabbit" <Jumping wrote:

I want to enter e-mail addresses without getting a hyperlink. If I have
dozens of e-mail addresses already with hyperlinks, how do I remove the links
in mass (I can do it one by one)?