The TEXTJOIN guide
=TEXTJOIN(", ", TRUE, B2:E2) joins the names in B2:E2 with a comma and a space between them. TRUE skips the empty cells, so a free seat doesn't leave a double comma.
Syntax
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
- delimiter: what goes between the items, in quotes.
", "is a comma and a space. - ignore_empty: TRUE skips empty cells, FALSE keeps them and puts a delimiter around each.
- text1, …: a range, or several cells and ranges.
TEXTJOIN is in Excel 2019 and later, Excel 365 and Excel for the web. In older versions it shows #NAME?.
Why not & or CONCAT?
=B3&", "&C3&", "&D3&", "&E3 joins every cell, empty or not. With seats 2 and 4 free, Pivot tables comes out as "Mei, , Jonas, ". CONCAT has the same problem and no delimiter at all. TEXTJOIN puts the delimiter only between the items it keeps.
TRUE or FALSE?
Almost always TRUE. FALSE is for when the position matters, such as a CSV line where an empty field must stay an empty field.
Other delimiters
"; "for a list of email addresses to paste into Outlook's To line.CHAR(10)for one item per line in the cell, with Wrap Text on." / "or" | "for codes.
Common mistakes
- FALSE as the second argument. Commas pile up where cells are empty.
- "," without the space. The names come out as Priya,Omar,Lena.
- A range that includes the label column. The session name ends up in the list.
Joining two cells into a full name: & and CONCAT.
FAQ
- How do I join cells with a comma in Excel?
- Use =TEXTJOIN(", ",TRUE,B2:E2). It puts a comma and a space between the values and skips empty cells.
- What does TRUE mean in TEXTJOIN?
- It tells TEXTJOIN to ignore empty cells. With FALSE, every empty cell gets a delimiter too, so commas pile up.
- What is the difference between TEXTJOIN and CONCAT?
- CONCAT joins values with nothing in between and keeps empty cells. TEXTJOIN puts a delimiter between the values and can skip empty cells.
- Why does TEXTJOIN show #NAME?
- The file is open in a version of Excel older than 2019, which doesn't have TEXTJOIN.



































































