Thread: Writing to csv
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default Writing to csv

Excel doesn't normally do that. There must be something in the 4th column
that is causing the comma after the 3rd one. Maybe right that column in the
sheet and delete it to make sure there is nothing there.

"Jeff" wrote:

Hi,

I am writing data to a csv. There are 3 columns.

I want the csv output to look like this (without a comma after the last
column data)

Column1 Column2 Column3
data,data2,data3
data,data2,data3
......

But the csv looks like
data,data2,data3,
data,data2,data3,

Thanks for your help