Save as CSV: extra spaces around commas

R

rjml

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.
 
N

Niek Otten

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

rjml

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

*.csv format change if .xlt save as .csv in Excel 2007 1
Save as CSV 2
Format changed if we save our own (.xlt) file as (.csv) in Excel 2 1
Saving double-byte characters as unicode text in a CSV file 4
Save as CSV not saving the same from Excel 2007 then in Excel 2003 1
Saving text with commas in a .csv file then converting to a .txt f 3
Saving as a text file with quotes AND commas 3
Save as CSV isn't saving comma delimited, but is using semi-colon. 2

Top