Community archive

Ask something
Discussion Locked

Microsoft Excel 97 CSV conversion

0 helpful
4 replies

by leebinhw

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Have been using the csv file type option to save worksheets into csv (comma delimited) file. Observed that the comma is not showing up from row 17 (1st row = header) onwards. Is there a setting in Excel that controls the maximum nbr of rows. see attached csv file for illustration.

A,B,C
A1,B1,
A2,B2,
A3,B3,
A4,B4,
A5,B5,
A6,B6,
A7,B7,
A8,B8,
A9,B9,
A10,B10,
A11,B11,
A12,B12,
A13,B13,
A14,B14,
A15,B15,
A16,B16
A17,B17

4 replies

by tracyp

Have you looked at the list separator value in your regional settings in control panel?

by leebinhw

Hi Tracy,

Current value is "," (comma), is this correct? If not correct, what should be the value set as?
Thanks for offering your assistance.

Regards,
Bin Hwee

by leebinhw

Found a workaround to resolve the problem. Just need to type a space (if original null)
in the last cell eg C2 in the below example.

A B C
1
2 X

by b2a.survsat

Lee,

If you leave empty cells at the end of your rows, Excel will not write them out. The third cell in the rows without the final comma, was empty. the third cell where the comma printed was a blank or blanks, not empty.

Similarly, at the endof the file, if you had rows of blanks, you would have gotten rows of commas without visible data.

Russell

This discussion is closed to new replies.