format cell content as hyperlinked email address
 

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?
--
Slan.

format cell content as hyperlinked email address
 

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

"Liam" wrote:

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?
--
Slan.

format cell content as hyperlinked email address
 

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


"yzhang00`" wrote:

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

"Liam" wrote:

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?
--
Slan.

format cell content as hyperlinked email address
 

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

--
HTH,
David McRitchie, former Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm



"yzhang00`" wrote in message ...
you can try, Tools - AutoCorrect Options - Autoformat as you type - click
"Internet and network paths in hyperlinks"

"Liam" wrote:

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?
--
Slan.

format cell content as hyperlinked email address
 

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




On Thu, 25 Sep 2008 12:17:04 -0700, Liam
wrote:

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?