
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 …
Excel save-as CSV options -- possible to change comma to pipe or tab ...
Jul 14, 2014 · Is there a way to tell Excel which delimiter to use when producing a CSV, e.g. tab or pipe?
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 …
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 split comma separated numbers using a formula
Oct 9, 2019 · How to split comma separated numbers using a formula Ask Question Asked 6 years, 4 months ago Modified 1 year, 11 months ago
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 …
Easiest way to open CSV with commas in Excel - Super User
Mar 31, 2012 · CSV files are automatically associated with Excel but when I open them, all the rows are basically in the first column, like this: It's probably because when Excel thinks "comma-separated …
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 can I use Excel to replace values in a comma separated list with ...
Nov 2, 2023 · How can I use Excel to replace values in a comma separated list with values in another cell? Ask Question Asked 2 years, 3 months ago Modified 2 years, 3 months ago
Comma style button to format numbers with 1,000 separators in Excel …
Aug 25, 2023 · To help, I often format cells with 1,000 separators. However, the 'comma style' button in the number group on the home tab of the ribbon (pictured below) automatically formats numbers to 2 …