format cell content as hyperlinked email address

[Liam]

i imported a contact list from outlook to excel 2003 but the email addresses
are only text - any way to format an entire column instead of one by one?

 

[yzhang00`]

you can try, Tools - AutoCorrect Options - Autoformat as you type - click
"Internet and network paths in hyperlinks"

 

[Liam]

Thank you but I tried that & it doesn't work. But further down in the
discussions I found a macro that solved the problem.

 

[David McRitchie]

See http://www.mvps.org/dmcritchie/excel/buildtoc.htm#MakeEmailLinks
be sure to copy and paste into your browser to pick up the #MakeEmailLinks

 

[Gord Dibben]

In an adjacent column

="mailto:" & HYPERLINK(A1)

Adjust the A1 to your column and start cell.

Double-click the fill handle to copy down.


Gord Dibben MS Excel MVP