| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| email hyperlink won't change when cell content changes | Excel Discussion (Misc queries) | |||
| find email address in a cell | Excel Worksheet Functions | |||
| How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
| Don't Want Email Addresses Hyperlinked | Excel Discussion (Misc queries) | |||
| How to format a cell as email address | Excel Discussion (Misc queries) | |||
Hybrid Mode
