Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
When I save a spreadsheet as CSV, and some of the fields at the end of
the row are empty (ie row 1 has 10 fields, and subsequent rows have <10 fields), some rows have consecutive comma's at the end of the row for the empty fields, and some do not. Anyone see/hear of this behavior? I'm using Excel 2002 SP3. To reproduce the problem, try entering 1 - 5 in cells A1 - E1, then enter 1 & 2 in columns A & B for the next 20 rows. Save as CSV, and open in notepad, rows 2 - 16 have three comma's at the end, & rows starting at 17 do not. The problem always starts at row 17 for me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Path\File name length problem Excel Crash on save as | Excel Discussion (Misc queries) | |||
save problem | Excel Discussion (Misc queries) | |||
problem with save files from office 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 crashing during "Save As" action. | Excel Discussion (Misc queries) | |||
Updating database worksheet problem (Template Wizard) | Excel Discussion (Misc queries) |