Open CSV file auto delimites using space not comma
 

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

Open CSV file auto delimites using space not comma
 

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
"Andy Dale" <Andy wrote in message
...
| 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
|

Open CSV file auto delimites using space not comma
 

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

"Jim Rech" wrote:

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
"Andy Dale" <Andy wrote in message
...
| 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
|