Excel 2003 column formatting question
 

I imported a text file that has names and email addresses.
How do I format the column with the email addresses so they become real html
email address instead of plain text.

Thanks to all replies.

Excel 2003 column formatting question
 

You can't do it by formatting alone.

You could use a macro to do the insert|hyperlink based on the contents of the
cell -- or even easier you could use another column with a formula like:

=hyperlink(a1,"email me")
or
=hyperlink("mailto:" & a1,"email me")


FrankSpokane wrote:

I imported a text file that has names and email addresses.
How do I format the column with the email addresses so they become real html
email address instead of plain text.

Thanks to all replies.

--

Dave Peterson