I have data on a sheet in six columns from A1 to F1
and I have over 100 lines below that
When I save this file as a CSV files, this is what I get

Apple pie, butter,dough,paper
plate,oven,high,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,

I get this for EVERY line on the sheet. (ie) a whole bunch of commas
after the data.
How do I stop that
Thanks

Try resetting the used range.

Debra Dalgleish shares some tips he
http://contextures.com/xlfaqApp.html#Unused

Saved from a previous post:

Lots of programs won't care if there are extra trailing commas at the end. For
instance, excel won't care.

But if you do...

Saved from a previous post:

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".)

(But a lot of programs (excel included) don't care about those extra columns.
Maybe you don't have to care, either???)

Maybe you could write your own exporting program that would behave exactly the
way you want:

Here are some sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html


On 07/23/2010 21:55, pcor wrote:
I have data on a sheet in six columns from A1 to F1
and I have over 100 lines below that
When I save this file as a CSV files, this is what I get

Apple pie, butter,dough,paper
plate,oven,high,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,

I get this for EVERY line on the sheet. (ie) a whole bunch of commas
after the data.
How do I stop that
Thanks

--
Dave Peterson