Open CSV file auto delimites using space not comma

[Andy Dale]

Hi,
I have a standard CSV file which when opened Excel (2003 SP3) automatically
uses the spaces as a delimiter rather then the commas. How do I ensure Excel
automatically opens CSV files and used commas as a default rather then spaces
as a delimiter. I have Excel 2007 which reads the file correctly.
Cheers

 

[Jim Rech]

The List Separator character designated under Windows Control Panel,
Regional Settings, Customize, Numbers controls Excel. When I changed mine
to a space a CSV file created in Excel 2003 used a space as the delimiter.
And on importing it ignored commas and parsed on spaces. So you might check
your Regional Settings.

--
Jim
| Hi,
| I have a standard CSV file which when opened Excel (2003 SP3)
automatically
| uses the spaces as a delimiter rather then the commas. How do I ensure
Excel
| automatically opens CSV files and used commas as a default rather then
spaces
| as a delimiter. I have Excel 2007 which reads the file correctly.
| Cheers
|

 

[Mark]

I have a similar problem and when I check my regional settings it has a comma
for list separater but when I open and csv in excel it picks up the tabs as
delimiter not the comma