Saving as CSV File

[mattman123]

Hello, I have a quick question regarding saving a worksheet as a .csv file.

The data I have looks something like this:

1 2
1 2 3 4 5

where each number is in a different cell.

When I save as a csv file, the file i get looks like this:

1,2,,,,
1,2,3,4,5

Is there anyway to not get the blank comma fields like that? Any work arounds? I would like the file to look like:

1,2
1,2,3,4,5

Thank you!
Mattman123

[millz]

A csv file should appear like this

1,2,,,,
1,2,3,4,5

because each , represents a column separator when opened with Excel. If you want it as text file instead but with a .csv extension you probably need to write it with VBA.