| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I open a comma delimted file so that all the fields are se | Excel Discussion (Misc queries) | |||
| I open a CSV file with excel, but the text is separate with comma! | Excel Discussion (Misc queries) | |||
| add extra space before comma | Excel Worksheet Functions | |||
| Inserting a space after a comma | Excel Worksheet Functions | |||
| Create a form to open a comma delimited file | Excel Discussion (Misc queries) | |||
Threaded Mode
