TEXTJOIN combines a list or range of text with a separator between each item, and can skip empty cells. It's the cleanest way to turn a column into a comma-separated list.
=TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...])
delimiterignore_emptytext1text2, ...Join all the tags in A2:A7 into one cell separated by ", ", skipping blanks. Answer in C2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Emp ID | Name | Dept | Salary | |
| 2 | 1042 | Maya Patel | Finance | maya.patel@acme.co | $72,000.00 |
| 3 | 1187 | Leo Rossi | Support | leo.rossi@acme.co | $51,000.00 |
| 4 | 1305 | Ava Kim | Sales | ava.kim@acme.co | $64,000.00 |
| 5 | 1411 | Omar Ali | Marketing | omar.ali@acme.co | $58,000.00 |
| 6 | 1520 | Hana Tanaka | Sales | hana.tanaka@acme.co | $69,000.00 |
| Formula | Result | What it shows |
|---|---|---|
=TEXTJOIN(", ", TRUE, C2:C6) | Finance, Support, Sales, Marketing, Sales | Every department as one list. |
=TEXTJOIN(" | ", TRUE, B2:C2) | Maya Patel | Finance | Join across a row. |
=TEXTJOIN("-", FALSE, A2:A3) | 1042-1187 | Numbers are joined as text. |
Learning step by step? TEXTJOIN is covered in Lesson 26: TEXTJOIN Function of the free course.