Combine a FILTER Spill Range into One Cell in Excel
Question details
Combine multiple results from a FILTER formula into one cell using a chosen delimiter.

- 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.
Identify the range to return and the matching criteria range. Make sure your Excel version supports both FILTER and TEXTJOIN.
Wrap the FILTER formula in TEXTJOIN
Use this formula to join matching values into a single cell with a delimiter of your choice.
Click the cell where you want the combined list to appear.
In the formula bar, enter =TEXTJOIN(", ",TRUE,FILTER(A2:A100,B2:B100="Sales","")) and press Enter.
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.
Replace ", " in the formula with another delimiter, such as "; ". For separate lines, use CHAR(10) and select Home > Wrap Text.

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. Open the spreadsheet: Open WPS Spreadsheet and use File > Open to select your workbook.
- 2. Select the output cell: Click an empty cell where you want the combined list.
- 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. Format the result: To use line breaks, replace ", " with CHAR(10) in the formula and turn on Wrap Text from the Home tab.

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.




