Help Importing Text File and Getting Right Format

Help Importing Text File and Getting Right Format - Help Pls

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brando - 17 Apr 2008 02:11 GMT

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

Reply to this Message

Dave Peterson - 17 Apr 2008 02:35 GMT

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
>
[quoted text clipped - 13 lines]
>
> Brandon

Signature

Dave Peterson

Reply to this Message

Brando - 17 Apr 2008 02:58 GMT

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

Reply to this Message

Dave Peterson - 17 Apr 2008 03:17 GMT

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
>
[quoted text clipped - 9 lines]
>
> Brandon

Signature

Dave Peterson

Reply to this Message

Brando - 17 Apr 2008 03:37 GMT

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

Reply to this Message