Function Problems

Combine a FILTER Spill Range into One Cell in Excel

John WilsonJohn Wilson Nov 18, 2026 869 views

Question details

Combine multiple results from a FILTER formula into one cell using a chosen delimiter.

Combine a FILTER Spill Range into One Cell in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Create a readable list or CSV-style string from values that match a condition.
Observed behavior
The matching values appear as one text string in a single cell rather than spilling into multiple cells.
Before you start

Identify the range to return and the matching criteria range. Make sure your Excel version supports both FILTER and TEXTJOIN.

Solution 1Recommended

Wrap the FILTER formula in TEXTJOIN

Use this formula to join matching values into a single cell with a delimiter of your choice.

1
Select an output cell

Click the cell where you want the combined list to appear.

2
Enter the formula

In the formula bar, enter =TEXTJOIN(", ",TRUE,FILTER(A2:A100,B2:B100="Sales","")) and press Enter.

3
Adjust the ranges and condition

Replace A2:A100 with the values to return, and replace B2:B100="Sales" with your criteria range and condition. Keep the return and criteria ranges the same size.

4
Choose a separator

Replace ", " in the formula with another delimiter, such as "; ". For separate lines, use CHAR(10) and select Home > Wrap Text.

Wrap the FILTER formula in TEXTJOIN
Empty results: The final empty string in FILTER handles cases with no matches, and TRUE tells TEXTJOIN to ignore empty values.
Work with spreadsheet formulas

Combine Filtered Values in WPS Spreadsheet

Use TEXTJOIN and FILTER in WPS Spreadsheet to turn matching values into a single delimited list. Check that your installed WPS version supports both functions.

  1. 1. Open the spreadsheet: Open WPS Spreadsheet and use File > Open to select your workbook.
  2. 2. Select the output cell: Click an empty cell where you want the combined list.
  3. 3. Enter the formula: In the formula bar, enter =TEXTJOIN(", ",TRUE,FILTER(A2:A100,B2:B100="Sales","")) and press Enter. Replace the ranges and condition with your own.
  4. 4. Format the result: To use line breaks, replace ", " with CHAR(10) in the formula and turn on Wrap Text from the Home tab.
Combine matching values into a readable list in one cellChoose commas, semicolons, or line breaks as separatorsOpen and save Microsoft Excel XLSX filesWork in a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

How do I put each filtered value on a new line?

Replace the delimiter in TEXTJOIN with CHAR(10), then select the result cell and choose Home > Wrap Text.

What happens if FILTER finds no matching rows?

With "" as FILTER's third argument, the formula returns an empty result instead of a no-match error. TEXTJOIN ignores that empty value when its second argument is TRUE.

Can I join an existing FILTER spill range?

Yes. If the FILTER formula starts in D2, enter =TEXTJOIN(", ",TRUE,D2#) in another cell to join its spilled results.

Why does TEXTJOIN return a #VALUE! error?

One possible cause is that the joined text exceeds Excel's 32,767-character cell limit. Narrow the FILTER range or criteria to return fewer values.