csv - missing comma in last column

[andy]

Hi,

Using Excel 2000, SP3

Situation:
Trying to do a SaveAs from XLS to CSV

The last column has some cells containing data, but the
majority of the cells are blank

Issue:
It looks like Excel is not adding the last comma for the
majority of the blank cells (it does it for a few of
them), when the file is saved to CSV

Is there a patch to fix this bug?

The closest KB article i could find matching this problem
was #259208.

thanks,
ap

 

[EarlK]

You can fake the extra comma at the end with the Text Write Program by
specifying comma, CR, LF for the record delimiter. Try 44, 13, 10. 44 is
the code for a comma.

Regards from Virginia Beach,

EarlK
-------------------------------------------------------------

 

[David McRitchie]

In light of the MS KB article that was in this thread, I think I would
use the fill handle to copy a space character all the way down, which
is probably what I did to recreated a Windows Address Book
..csv file for importing back to the WAB. Pretty dumb to require
a delimiter at the very end.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

You can fake the extra comma at the end with the Text Write Program by
specifying comma, CR, LF for the record delimiter. Try 44, 13, 10. 44 is
the code for a comma.

Regards from Virginia Beach,

EarlK
-------------------------------------------------------------