Excel functions / Text
TEXTJOIN
Joins a range of text with a separator, such as a comma, between each item.
Syntax
=TEXTJOIN(delimiter, ignore_empty, text1, ...)Arguments
delimiter | What goes between each item, such as ", ". |
|---|---|
ignore_empty | TRUE to skip empty cells, so you do not get doubled separators. |
text1, ... | The cells or ranges to join. |
How it works
TEXTJOIN turns a column of names into one line, such as "Nina Shah, Omar Reid, Mary Ann Lee". The separator only goes between items, never at the end.
It is available in Excel 2019 and later.
Example
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | |||
| 2 | Nina Shah | nina.shah@example.com | Nina Shah, Omar Reid, Mary Ann Lee | |
| 3 | Omar Reid | omar@example.com | ||
| 4 | Mary Ann Lee | mary.lee@example.com | ||
| 5 |
Result: Nina Shah, Omar Reid, Mary Ann Lee. All three names, separated by a comma and a space.
Tips
- Use CHAR(10) as the delimiter to put each item on its own line, with Wrap Text turned on.
Practise TEXTJOIN
Try it yourself in a real spreadsheet, with instant feedback on every answer.