You can copy an empty cell, select the range(with the keyboard) and do
editpaste special and select add

a macro solution


http://www.mvps.org/dmcritchie/excel...#DelHyperlinks

Regards,

Peo Sjoblom

"kattnip333" wrote:

I have a list of people and their e-mail addresses but they come up blue
hyperlinks. I can individually right click and remove the hyperlink but I
have 700 to do and would like to highlite column and remove all at once but
don't know how. I also would like future addresses "Not" be hyperlinks...
I'm using Excell 2000