
Convert a column into a comma separated list - Super User
Apr 14, 2014 · Then export the data as a csv (comma-deliminated format), and you have your plaintext comma-seperated list! You can copy from notepad and put it back into excel if you want. Also, if the …
How to create a smart Excel filter for comma-separated values?
Aug 1, 2025 · I have attached a small example where the author names are comma-separated. Question: I know how to filter by single author but how to filter by multiple authors, regardless their …
Dot instead of comma on numerical keyboard - Super User
Apr 28, 2014 · Using polish language on Windows 8.1, comma is the default decimal seperator on numerical keyboard. Is there a way to change it to dot? I wouldn't like to change it in Excel or some …
How to get Excel to interpret the comma as a default delimiter in CSV ...
While opening CSV files, Excel will use a system regional setting called List separator to determine which default delimiter to use. Microsoft Excel will open .csv files, but depending on the system's …
What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV ...
Feb 2, 2012 · What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited) file types in excel 2010? They are all listed as a save file type, but ultimately are Comma …
Excel - use both comma and dot to separate decimals
Oct 4, 2016 · The problem is that eventhough all of my users are in central Europe which uses comma (",") as a decimal separator, some of them still use dot (".") as a decimal separator. Excel then treats …
How to make excel open CSV files and automatically split the comma ...
Here are some easy explanations on how to do it automatically when you open your file with Excel: As you said, Excel has a default character as a delimiter. In your case, this is ";" visibly. I am working on …
Excel merge comma separated cells - Super User
Apr 15, 2020 · Excel merge comma separated cells Ask Question Asked 5 years, 9 months ago Modified 5 years, 9 months ago
How do you change default delimiter in the Text Import in Excel?
The CSV file has comma separated data (go figure), but the delimiter in the Text Import Wizard is set to "Tab" by default. How can I change the default to "Comma" instead?
How do you force excel to quote all columns of a CSV file?
Apr 13, 2010 · Excel only places quotes around certain fields, how do I force excel to save a CSV file with quotes around every column?