View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PCOR PCOR is offline
external usenet poster
 
Posts: 77
Default Saving a CSV file

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