Importing Text File with Comma Seperated Data - Need Help Pls

B

Brando

Hi

I have a text file that has our customers emails separated by commas. I want
to get this list imported into excel with each of the email addresses
appearing on a separate row in one column.

I tried the import wizard and I get one of two results, all the emails in
separate columns. Meaning they all show up in Row A under Column A-ZZZ, or
they all show up in Row A Column A.

The goal is to get each one in a separate row all under column A.

Help is greatly appreciated.

Thank you

Brandon
 
E

Earl Kiosterud

Brando,

One way is to let it put them across a row as it's doing, then copy the row, then paste
special - transpose. This will only work if there are no more than 256 of them (more if
using Excel 2007), as that's the max count of columns. A macro could automate this.

Dave Peterson outlined a way in a later post to remove the commas using Word.
 

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

Help Importing Text File and Getting Right Format - Help Pls 4
Convert Numbers to Text with a Source Code list 2
Extracting Comma Seperated data into individual Cells 2
Importing a Text File Into 1 Column 3
Need to import data to a coloum not a row 1
Text File Importing 2
Importing a text file of individual records 3
Text Files 2

Top