Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel CSV file format issue...
Scenario: You have two columns in Excel. ColumnA contains 20 or so items, and
ColumnB only contains 1 item. If you save it as a CSV file and view it in NOTEPAD or some other text editor, the commas will stop being applied after the 16th row: ColumnA,ColumnB 123455,0 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455 123455 123455 123455 123455 123455 Which makes it useless really if you are using another program that reads comma-delimited files. Is this a Bug? Any ideas? |
#2
|
|||
|
|||
http://support.microsoft.com/default.aspx?scid=77295
Column Delimiters Missing in Spreadsheet Saved as Text If you need the comma, maybe you can just put ="" in the empty cells in column B. netjim66 wrote: Scenario: You have two columns in Excel. ColumnA contains 20 or so items, and ColumnB only contains 1 item. If you save it as a CSV file and view it in NOTEPAD or some other text editor, the commas will stop being applied after the 16th row: ColumnA,ColumnB 123455,0 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455, 123455 123455 123455 123455 123455 123455 Which makes it useless really if you are using another program that reads comma-delimited files. Is this a Bug? Any ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Troubel with compression of a very large Excel file | Excel Discussion (Misc queries) | |||
Excel File in Use Notification Missing?? | Excel Discussion (Misc queries) | |||
how to format and print labels from an excel file | Excel Discussion (Misc queries) | |||
Excel data file format | Excel Discussion (Misc queries) | |||
Problem opening an XML file in Excel - getting "ns1:macrosPresent" | Excel Discussion (Misc queries) |