Formula Errors

Fix Excel TEXTJOIN and FILTER Formula Error Caused by Separators

Huda QurayshiHuda Qurayshi Nov 13, 2026 869 views

Question details

The user needs to correct a TEXTJOIN and FILTER formula that stops working when regional settings change the Excel list separator from a comma to a semicolon.

Fix Excel TEXTJOIN and FILTER Formula Error Caused by Separators
Product
Microsoft Excel / WPS Office Spreadsheets
Device & OS
not provided
Scenario
A TEXTJOIN and FILTER formula stops returning expected results after the system's regional settings switch the list separator from comma to semicolon.
Observed behavior
The formula returns an error or incorrect result because commas are interpreted based on the current regional list separator.
Before you start

Before editing the formula, identify whether your current list separator is a comma or semicolon by checking a formula that is already working or by reviewing your operating system regional format settings.

Solution 1Recommended

Replace formula commas with semicolons to match regional list separator settings

Use this when your regional settings require semicolons as the argument separator in formulas.

1
Select the formula cell

Click the cell that contains the TEXTJOIN and FILTER formula, then click the formula bar in WPS Office Spreadsheets or Excel.

2
Replace argument separators

In the formula bar, change only the comma characters that separate formula arguments to semicolons. For example, change =TEXTJOIN(", ",TRUE,FILTER(...)) to =TEXTJOIN(", ";TRUE;FILTER(...)). Keep the delimiter ", " inside the quotes unchanged.

3
Apply and verify

Press Enter, then copy the formula to other cells if required. Confirm that TEXTJOIN returns the expected values and FILTER no longer returns an error.

Replace formula commas with semicolons to match regional list separator settings
Formula separators updated: Only argument separators change; commas inside quoted text such as the TEXTJOIN delimiter remain commas.
WPS Office Spreadsheets

Fix Separator-Related TEXTJOIN and FILTER Formula Errors in WPS Office

Use WPS Office Spreadsheets to open the workbook, adjust argument separators to match your regional settings, and restore TEXTJOIN and FILTER results while maintaining Excel compatibility.

  1. 1. Open WPS Office Spreadsheets: Launch WPS Office, click Sheets, and open the workbook that contains the TEXTJOIN and FILTER formula.
  2. 2. Select the affected formula: Click the cell with the formula to display it in the formula bar.
  3. 3. Adjust argument separators: In the formula bar, replace argument commas with semicolons if your system list separator is a semicolon, while leaving the quoted delimiter ", " unchanged.
  4. 4. Confirm and save: Press Enter, check that the formula returns the expected joined list, then save the workbook.
Fixes TEXTJOIN and FILTER separator errors without losing the original Excel workbook logic.Opens and saves .xlsx files with full formula and formatting compatibility.Free, lightweight, and easy-to-use spreadsheet tool for everyday Excel tasks.Uses a familiar formula bar and function syntax, making separator edits straightforward.
microsoft office alternative - wps office

Frequently Asked Questions

Why does the same TEXTJOIN formula require semicolons on another computer?

The argument separator is controlled by the operating system's regional list separator setting. A computer set to a locale that uses semicolons may require semicolons instead of commas, even when the file is the same.

Do I have to change every comma inside my TEXTJOIN and FILTER formula?

No. Only the commas that separate function arguments must be changed. Commas inside double quotes, such as the ", " delimiter passed to TEXTJOIN, should stay as commas.

Can I switch my list separator back to a comma instead of editing the formula?

Yes. In Windows Region settings, open Additional settings and change the List separator field to a comma, then restart the spreadsheet application. The original formula should work again.

Does WPS Office Spreadsheets support TEXTJOIN and FILTER?

Yes. WPS Office Spreadsheets supports these functions and can open Excel workbooks that use them, so you can fix the separator issue directly in WPS Office.