Importing Text File with Comma Seperated Data - Need Help Pls
 

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

Importing Text File with Comma Seperated Data - Need Help Pls
 

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.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Brando" wrote in message
...
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