Default column separator
Lieven
Is the file extension for your file .csv as Excel should automatically open this using the commas as the separators. If you have files that do not use commas as separators, suggest you have these as .txt files - when you open from Excel (Files-Open-Files of Type - select Text files from pull down list) the Text Import Wizard should start up - you can then select characters each time you open. BUT if you want to permanently use a different separator then the only solution I know is the one you've already tried by changing List Separator in Regional Settings - the only reason I can think of that this does not automatically work for you is because your source filename is not filename.csv as above... Steve "Lieven Mettepenningen" wrote: Hello, Is it possible to open a csv-file with a number of columns that are separated be a certain separator in Excel, so that Excel puts the text in the right columns automatically by looking at the separator. I want Excel to do this without using the wizard 'Text to Columns'. This works fine for me when I use the semicolon as separator. I presume this is the default separator. But how can I change this separator to for example a comma, so that Excel can also open my comma-separated files in a correct way automatically? I've already tried to change the 'List Separator'-setting in the 'Regional Settings' to a comma, but this doesn't work. Does anyone know the answer please? Thx, Lieven |
All times are GMT +1. The time now is 06:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com