e-mail list comes up as hyperllinks

[Guest]

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

 

[Guest]

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

a macro solution


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

Regards,

Peo Sjoblom