Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing extra spaces | Excel Discussion (Misc queries) | |||
How Do I Add Commas To Columns And Remove Spaces In Excel?? | Excel Discussion (Misc queries) | |||
eliminating extra spaces in Excel cells | Excel Discussion (Misc queries) | |||
Removing random extra spaces | Excel Discussion (Misc queries) | |||
Extra Spaces with copied data | Excel Discussion (Misc queries) |