Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Tab Delimited Text File to A Comma Delimited Text File
How does changing the delimiter affect the number of columns in that row?
wrote: I have a situation where I need to convert a tab delimited text file to a comma delimited text file. It would be an easy process but the number of colums to be imported into excel exceeds MS Excel's 256 column limit. I would appreciate any help that you could provide me. The data is currently in the format below: 1234 45676 4332.23212 23334.21 with the spaces in between the numbers being tab spaces. I would like to convert it to the format below: 1234,45676,4332.23212,23334.21 And then to be able to input each number into a separate column. Thanks in Advance, Kwesi -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving multi-tab excel file created from comma delimited text file | Excel Programming | |||
How can I save a file as a comma-delimited text file in Excel? | Excel Discussion (Misc queries) | |||
how to save a file as ASCII: expanded comma delimited text (.exp). | Excel Discussion (Misc queries) | |||
I have a Comma delimited text file how do I import in to excel an. | Excel Discussion (Misc queries) | |||
Comma Delimited Text File Issue | Excel Programming |