I had the same quetion ealier this week and Dave Peterson gave this reply:
"This might describe the problem of too many commas in CSV files:
http://support.microsoft.com/default.aspx?scid=77295
Column Delimiters Missing in Spreadsheet Saved as Text
(It actually describes missing delimiter, but if some are "missing", maybe the
ones appearing are "extra".)
Maybe you can just fill the empty cells with your own placeholders.
I'd use a formula like this:
=""
--
Dave Peterson"
I used the ="" formula and filled it down both empty columns, saved as .csv,
and it work fine.
"BrianFromMN" wrote:
I need to save an Excel spreadsheet to a delimited text file, (either tab or
comma). The last 2 columns are blank on the spreadsheet. The delimiters
for the blank fields stop showing on the text file after 15 records. I went
back into the 16th row on spreadsheet and typed a space in each of the last 2
columns. When I save that as a delimited text file, the delimiters were at
the end of the records for the 1st 15, the 16th, and the next 15, but then
they stop again. I need those delimiters for those blank fields. Any help
will be greatly appreciated.