Help Importing Text File and Getting Right Format - Help Pls

  • Thread starter Thread starter Brando
  • Start date Start date
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
 
I'd open the text file in MSWord.
Then change all the commas to a paragraph mark
Look under the Edit|Replace dialog's More Button, then Special Button (at the
top)

Then make sure you save this file as plain text.

Then you can open the file in excel -- or maybe keep it in MSWord???
 
Hi Dave

Thanks. I did what you suggested and when I import the data it still shows
up all in one cell.

I need to get it into excel so I can sort the data and edit out some of the
repeating data.

Any other suggestions. I know this has to be possible, I just can not get it.

Thanks again

Brandon
 
Are you sure you saved the file as a .txt file?

How about another attempt, but this time, do the MSWord stuff. (You did see the
data become a list (essentially) in MSWord, right???)

This time, just select the single column in MSWord and edit|Copy

Back to excel
Edit|Paste special|text
 
Hi Dave

Thank you very much. I was a moron, I did the replace with the paragraph
symbol vs the paragraph mark which causes a return. Simple mistake = wrong
result :-)

Thanks again for your help, it is greatly appreciated!

If you happen to fish email me at Brandon at LateralLineCo.com and I will
send you a hat for your thanks.

Brandon
 
Back
Top