[Nancy]

I have a listing of names & addresses, etc, in a comma-delimited text format.
I have tried to convert the listing to a table in Word, and then
transferring the data to Excel. I think I'm trying to do the impossible, but
this list consists of 3,000 names and I want to be able to sort by State,
either in Word or Excel. I don't have the programming knowledge to do this.
Can anyone help, please??????

[Klaus Linke]

"Nancy" wrote:
I have a listing of names & addresses, etc, in a comma-delimited text
format.
I have tried to convert the listing to a table in Word, and then
transferring the data to Excel. I think I'm trying to do the impossible,
but
this list consists of 3,000 names and I want to be able to sort by State,
either in Word or Excel. I don't have the programming knowledge to do
this.
Can anyone help, please??????


Hi Nancy,

If it's a comma delimited text file, Excel has a wizard that takes you
through all the steps.

Just try to open the text file in Excel... Have you tried it?
It's probably much easier than going through Word.

Klaus

[Nancy]

Hello Klaus,
Thank you for responding. I received the listing as an e-mail and have just
re-saved it as a .txt file. I did open it in Excel, but the information runs
together, not each comma-delimited field in a separate cell. Is there a way
for me to format the spreadsheet?
Thanks again,
Nancy

"Klaus Linke" wrote:

"Nancy" wrote:
I have a listing of names & addresses, etc, in a comma-delimited text
format.
I have tried to convert the listing to a table in Word, and then
transferring the data to Excel. I think I'm trying to do the impossible,
but
this list consists of 3,000 names and I want to be able to sort by State,
either in Word or Excel. I don't have the programming knowledge to do
this.
Can anyone help, please??????


Hi Nancy,

If it's a comma delimited text file, Excel has a wizard that takes you
through all the steps.

Just try to open the text file in Excel... Have you tried it?
It's probably much easier than going through Word.

Klaus

[Dan Freeman]

Change the file's extension from .txt to .csv

Dan

Nancy wrote:
Hello Klaus,
Thank you for responding. I received the listing as an e-mail and
have just re-saved it as a .txt file. I did open it in Excel, but
the information runs together, not each comma-delimited field in a
separate cell. Is there a way for me to format the spreadsheet?
Thanks again,
Nancy

"Klaus Linke" wrote:

"Nancy" wrote:
I have a listing of names & addresses, etc, in a comma-delimited
text format.
I have tried to convert the listing to a table in Word, and then
transferring the data to Excel. I think I'm trying to do the
impossible, but
this list consists of 3,000 names and I want to be able to sort by
State, either in Word or Excel. I don't have the programming
knowledge to do this.
Can anyone help, please??????


Hi Nancy,

If it's a comma delimited text file, Excel has a wizard that takes
you through all the steps.

Just try to open the text file in Excel... Have you tried it?
It's probably much easier than going through Word.

Klaus

[Klaus Linke]

"Dan Freeman" wrote:
Change the file's extension from .txt to .csv

Maybe that'll do the trick, though the text conversion wizard kicks in any
time I try to open a text file, no matter what the extension.

If it doesn't for Nancy, maybe someone in the Excel groups knows what
option(s) to change...

Regards,
Klaus

[Dan Freeman]

Klaus Linke wrote:
"Dan Freeman" wrote:
Change the file's extension from .txt to .csv

Maybe that'll do the trick, though the text conversion wizard kicks
in any time I try to open a text file, no matter what the extension.

If it doesn't for Nancy, maybe someone in the Excel groups knows what
option(s) to change...

I've never actually seen that wizard. g When I double-click a CSV file,
Excel jumps up and properly parses it.

Dan