Open CSV file auto delimites using space not comma

  • Thread starter Thread starter Andy Dale
  • Start date Start date
A

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
 
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
|
 
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
 
Back
Top