We help IT Professionals succeed at work.
Get Started

Importing a ".txt" file's comma separated e-mail addresses into Excel

cjseipp asked
Last Modified: 2009-12-16
Here is what I have.

A ".txt" file that contains valid e-mail addresses seperated by commas.

This was created by copying a collection of 200+ e-mail addresses that were seperated by commas. Then I pasted them into  a blank Notepad document. Then saved the file with the default ".txt" extension.

Here is what I wish to accomplish:
Take the text file containing the data and produce a file that could be used to import the e-mail addresses into Outlook,

Outlook Express, Eudora or any other e-mail program the client is using.

Here is what I have tried:

Opened a blank worksheet in Excel. Created a header in cell A1 named "email address". Pasted the list of e-mail addresses from the Text file into cell A2. Save as a csv file. This Excel CSV file when imported produces a single contact with all addresses that were pasted into cell A2.........

Here is what I believe needs to occur:

Importing/Inserting/Copying the list of e-mail addresses into individual cells in Column A(with cell A2 reserved for the Field Name "email address")

Can this be automated via a Script, Macro etc? I am a novitiate with these techniques, but will pursue those paths if necessary.

Thanks for the help,

I have enjoyed your site's support and knowledge base.

Watch Question
Top Expert 2008
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant

An Experts Exchange subscription includes unlimited access to online courses.

Get Started
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE