column of e-mail addresses not hyperlinked

M

Matthew

I have an Excel spreadsheet that is connected to a text file for the
majority of its data. This works great except that one of the columns
from the text file contains e-mail addresses. These addresses are not
hyperlinked in Excel i.e. one cannot click on them and launch an
e-mail application - no mailto:. How can I format this column to
recognize that it contains e-mail addresses? This is on Excel 2000
and the data is gotten from the text file via data -> get external
data > refresh. thanks!
 
D

Dave Peterson

How about using a helper column of cells:

Say your email addresses are in column C, then insert a new column D and use
this formula:

=hyperlink("mailto:"& c1,c1)

(if you want you could hide column C and just keep column D showing.)
 
M

Matthew

Work great! thanks!

Matthew

Dave Peterson said:
How about using a helper column of cells:

Say your email addresses are in column C, then insert a new column D and use
this formula:

=hyperlink("mailto:"& c1,c1)

(if you want you could hide column C and just keep column D showing.)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to extract e-mail addresses found in Excel 3
Can I sort text data by reference to text data in another column? 1
Importing E-Mail Addresses 1
E-Mail Issue in Excel 5
Retrieve E-mail addresses from mailto objects 1
How do I permanently deactivate auto e-mail in Excel? 2
Copy email addresses from excel to windows mail 3
How to convert hyperlink in Excel to show hyperlinked address? 5

Top