I am trying to create a csv from another application to be imported into
Excel. One of the columns will contain email addresses. Is there a way that I
can format the data in the column to have the addresses be 'links' when
brought into Excel.

First, hyperlinks are not just formatting. The Insert|hyperlink style of
hyperlinks are objects in excel.

Second, CSV files are plain old text. They don't hold these kinds of objects.
(And they also don't contain any formatting properties, either.)

But third, you may be able to cheat a bit.

Can you go back to the other application and have them change the way the email
field in the CSV file is created.

If you can get them to create a text field that looks like:
"" )"

like:

1234,"=hyperlink(""mailto:emailaddresshere@domain. com"")","another field",...

For me, xl2003 (with my USA function names) sees this field as a formula. The
cell isn't formatted to show a hyperlink (in my simple tests). But when you
click on one of those cells, the default email program starts up correctly.

============
Alternatively, instead of opening the .CSV file by just double clicking on it or
using File|open (in xl2003 menus), you could open the file using a macro in a
workbook dedicated to opening these CSV type files.

Then the macro could open the file and even convert the values in the fields to
hyperlinks.




email addresses in csv file wrote:

I am trying to create a csv from another application to be imported into
Excel. One of the columns will contain email addresses. Is there a way that I
can format the data in the column to have the addresses be 'links' when
brought into Excel.

--

Dave Peterson