Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Comma-delimited text format
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?????? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Comma-delimited text format
"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 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Comma-delimited text format
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 |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Comma-delimited text format
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 |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Comma-delimited text format
"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 |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Comma-delimited text format
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 |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Comma-delimited text format
My bad... you're right!
I don't know why Nancy didn't see the wizard for her *.txt file though... But then I don't know much of anything about Excel. Klaus "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 |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Comma-delimited text format
I actually try to avoid Excel g, but I've been using it lately to check
CSV output from an application. Dan Klaus Linke wrote: My bad... you're right! I don't know why Nancy didn't see the wizard for her *.txt file though... But then I don't know much of anything about Excel. Klaus "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 |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Comma-delimited text format
Klaus & Dan,
I so appreciate your input. I cannot seem to get this to work. Dan, you mentioned that when you double-click a CSV file, excel jumps up and properly parses it. I'm not sure if I'm doing this right....I saved the e-mail as a ..txt file then opened it in Excel, and re-saved it as a CSV file with the same results. I don't know what "parses" means. Perhaps I need a "computing for dummies" - I'm blonde, but ....... Nancy "Dan Freeman" wrote: I actually try to avoid Excel g, but I've been using it lately to check CSV output from an application. Dan Klaus Linke wrote: My bad... you're right! I don't know why Nancy didn't see the wizard for her *.txt file though... But then I don't know much of anything about Excel. Klaus "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 |
#10
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Comma-delimited text format
Just rename the original file using Windows Explorer. Once you've renamed
it, double click on it (again, in Windows explorer). If it was already comma-delimited, there's not need to re-save it. Just rename it. Might be a good idea at this point and go back to the original Email, and this time when you save the attachment give it the .csv extension instead of .txt. Parsing just means that Excel properly puts the values between each comma in a column of its own. Dan Nancy wrote: Klaus & Dan, I so appreciate your input. I cannot seem to get this to work. Dan, you mentioned that when you double-click a CSV file, excel jumps up and properly parses it. I'm not sure if I'm doing this right....I saved the e-mail as a .txt file then opened it in Excel, and re-saved it as a CSV file with the same results. I don't know what "parses" means. Perhaps I need a "computing for dummies" - I'm blonde, but ....... Nancy "Dan Freeman" wrote: I actually try to avoid Excel g, but I've been using it lately to check CSV output from an application. Dan Klaus Linke wrote: My bad... you're right! I don't know why Nancy didn't see the wizard for her *.txt file though... But then I don't know much of anything about Excel. Klaus "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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I remove spaces from a comma delimited file in Word | Microsoft Word Help | |||
Mail Merge - Comma delimited data into table | Mailmerge | |||
Word should let me sort a comma delimited list | Tables | |||
What is ASCII Foxed Width or comma delimited format? | Microsoft Word Help | |||
comma delimited text | Mailmerge |