Save as CSV: extra spaces around commas
 

Excel 2007 Save As CSV - MS-DOS adds extra spaces in the comma-delimited
file. (My List Separator in Regional Settings is simply comma, not
space-comma or so.)

So, I get
MC-001A, 192.00 , 7.00 , 6.60 , 91.00 , V-TOP
instead of
MC-001A,192.00,7.00,6.60,91.00,V-TOP

How do I fix this? Thanks.

Save as CSV: extra spaces around commas
 

I can't reproduce that.
Are you sure the spaces aren't already in your cells?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"rjml" wrote in message
...
Excel 2007 Save As CSV - MS-DOS adds extra spaces in the comma-delimited
file. (My List Separator in Regional Settings is simply comma, not
space-comma or so.)

So, I get
MC-001A, 192.00 , 7.00 , 6.60 , 91.00 , V-TOP
instead of
MC-001A,192.00,7.00,6.60,91.00,V-TOP

How do I fix this? Thanks.

Save as CSV: extra spaces around commas
 

In this line

MC-001A, 192.00 , 7.00 , 6.60 , 91.00 , V-TOP

the middle four fields are numbers in the corresponding Excel columns. So,
you cannot really put spaces in. They are centered, but changing that did not
make any difference (and formatting will be lost anyway going to CSV).

RJ

"Niek Otten" wrote:

I can't reproduce that.
Are you sure the spaces aren't already in your cells?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"rjml" wrote in message
...
Excel 2007 Save As CSV - MS-DOS adds extra spaces in the comma-delimited
file. (My List Separator in Regional Settings is simply comma, not
space-comma or so.)

So, I get
MC-001A, 192.00 , 7.00 , 6.60 , 91.00 , V-TOP
instead of
MC-001A,192.00,7.00,6.60,91.00,V-TOP

How do I fix this? Thanks.