format cell content as hyperlinked email address

L

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?
 
Y

yzhang00`

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

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.
 
G

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
 
Top