Converting text to hyperlink in Excel 2000

[Robin Cowdrey]

I have a database of approximately 100 people who belong to the same club
that I do. It includes email addresses but not all of them are in hyperlink
format. Is there an easy way of converting them all at once?

Robin

 

[Frank Kabel]

Hi
check out:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
(in the middle of this page)

 

[Peo Sjoblom]

Assuming they are correct email addresses you can find how to run a macro here

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


Regards,

Peo Sjoblom