I have a weird one. I am saving an Excel file as a CSV file and the first 15 rows of data have extra commas at the end of the record. The extra commas are due to two column headings at the end which have no data in the rows. I can delete a bunch of columns to the right of the data and even delete a chunk of the rows and yet the initial 15 rows have two extra commas. It is like Excel figures out that there really isn't any data in those columns and so it drops the commas from the 16th row on.
Interestingly enough this happens to a new file. Just add a few columns with 20+ rows of data. Then add a couple column headings to ROW 1 with no data in those columns. Save as CSV, look at it in NOTEPAD...you will be amazed!!
Don't care whether the commas are there or not...just want it to be the same for every row.
FYI - Running Excel 2000 SR-1
Thanks in advance.
Interestingly enough this happens to a new file. Just add a few columns with 20+ rows of data. Then add a couple column headings to ROW 1 with no data in those columns. Save as CSV, look at it in NOTEPAD...you will be amazed!!
Don't care whether the commas are there or not...just want it to be the same for every row.
FYI - Running Excel 2000 SR-1
Thanks in advance.