Syntax
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)| Argument | What it means |
|---|---|
delimiter | What to put between items, such as ", ". |
ignore_empty | TRUE to skip blank cells. |
text1, ... | The cells or ranges to join. |
Examples with results
Every result below is calculated by the practice engine on the sample data shown, not typed in by hand.
Team list (fictional)
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Name | Department | Salary | Start date | Rating |
| 2 | Amira Hassan | Finance | 9200 | 2019-03-04 | 4 |
| 3 | Ben Carter | Sales | 7800 | 2021-07-19 | 3 |
| 4 | Chen Wei | Sales | 8100 | 2020-01-13 | 5 |
| 5 | Dina Ali | HR | 7200 | 2022-09-01 | 4 |
| 6 | Emil Novak | Operations | 6900 | 2018-11-26 | 2 |
| 7 | Farah Khan | Finance | 10400 | 2016-05-09 | 5 |
| 8 | Gabriel Silva | Operations | 6500 | 2023-02-14 | 3 |
=TEXTJOIN(", ",TRUE,B2:B8)List every department, comma separated
List A and list B (fictional)
| Row | A | B |
|---|---|---|
| 1 | Ordered | Received |
| 2 | P-101 | P-102 |
| 3 | P-102 | P-101 |
| 4 | P-103 | P-105 |
| 5 | P-104 | P-103 |
| 6 | P-105 |
=TEXTJOIN(", ",TRUE,B2:B6)Received items, ignoring the empty cell
Try it yourself
Change the formula or switch to other sample data.
Press Calculate to see the result.
The practice box runs in your browser with BDK’s own calculator, which covers about 60 common functions. Cell references work as in Excel (B2, B2:B9). Your formulas are not saved or sent anywhere. For anything unusual, check the result in Excel itself.
How people use TEXTJOIN at work
- Administration
Make a comma list from a column.
Data: Price list (fictional)=TEXTJOIN(", ",TRUE,A2:A6) - Operations
List items that are low on stock.
Data: Stock levels (fictional)=TEXTJOIN(", ",TRUE,B2:B6)
Common mistakes and tips
- TEXTJOIN does not remove duplicates. Clean the list first.
Works in
Excel 2019 and Microsoft 365 or later, and Google Sheets. Not in Excel 2016 or older.
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.