Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
default row height and column widths | New Users to Excel | |||
Copying the contents of a column into a chart | Excel Worksheet Functions | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |