- The list separator in Windows - Regional Settings does not match what is being typed for the Excel formula.
- The 'Use system separators' option is set in Excel Advanced Options and does not match what is being typed for the Excel formula.
If the 'Use system separators' is enabled then look in the Region (Regional) Settings in the Windows Control Panel. The list separator is specified in the Additional settings.
2. Use the same character as the designated list separator in Windows settings when creating the formula(s).
Note: The comma is the default list separator for US - English Locale.
Article ID: 2853427 - Last Review: Sep 23, 2015 - Revision: 1