Be sure you and Excel agree on where the last used cell is. Press CTRL+END to
find out what Excel thinks. If it is too far to the right or down, DELETE the
extra columns and rows using Edit/DELETE, Entire Column and Entire Row (not
the DEL key).


On Mon, 6 Dec 2004 03:09:01 -0800, One-eyed-Ian
wrote:

When attempting to convert an .xls format to .csv format using Excel to do
the conversion process, I am getting too many commas at the end of a number
of lines (where there is NO data at all). It may be linked to some preview,
I see some resemblance between 'web page preview' and the resultant output.
Would like to just save a file with variable numbers of (and items of) data
on separate lines of the same file, and for the .csv file to have the correct
number of commas per line. How can this be achieved?