In Excel: use =TEXTJOIN(delimiter, ignore_empty, range) — it joins a whole range into one string, putting your delimiter between items and optionally skipping blank cells.
Syntax
Arguments
| Argument | Description | |
|---|---|---|
delimiter | required | The text placed between each item, such as ", " for a comma-separated list. |
ignore_empty | required | TRUE skips blank cells (so no double delimiters); FALSE keeps them. |
text1 | required | The first cell, range or string to join, such as A2:A6. |
text2, ... | optional | Optional further cells, ranges or strings to append. |
Related functions
In the result cell type =TEXTJOIN( and type the delimiter in quotes, such as ", " for a comma-separated list.
Type a comma, then TRUE to skip blank cells (or FALSE to keep them).
Type a comma and select the range to join, such as A2:A6.
Close the bracket and press Enter to see the combined string.
Add more comma-separated ranges or cells before the closing bracket if the values are spread out.
What this does
TEXTJOIN joins many values into one string with a delimiter you set once, and it accepts a whole range rather than item-by-item arguments — its two big advantages over CONCATENATE. The first argument is the separator (for example ", "), the second decides whether blank cells are skipped (TRUE) or kept as empty slots (FALSE), and then you point it at a cell, a range, or several of them. With ignore_empty TRUE you never get doubled-up delimiters from gaps in the data. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. For “use textjoin in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That is what makes a text operation that turns messy entries into clean, usable data useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
Tags sit in A2:A6 as "red", "", "blue", "", "green" with two blanks. =TEXTJOIN(", ", TRUE, A2:A6) returns "red, blue, green" — the comma-space separates each value and the empty cells are skipped, so there are no ", ," gaps. With FALSE instead of TRUE it would return "red, , blue, , green", keeping the blanks as empty entries. TEXTJOIN is the modern way to build delimited lists from a column — comma-separated tags, address lines, email recipients — joining a range in one step and skipping the blanks. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.
In Google Sheets
Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. Keep this page bookmarked for the next time the same question comes up. Better still, rebuild the example once in your own sheet — doing it yourself, with the tool above to check against, is what turns a copied formula into a technique you own. Here is the takeaway for “use textjoin in excel”: copy the answer if you are busy, but if you have a spare few minutes, rebuild the example in Excel yourself with the tool above open beside it. That single pass — type it, run it, watch the result move when you change an input — is what turns a formula you found into a technique you trust. Keep your inputs labelled and referenced, never hard-coded, and the same sheet stays correct and auditable as it grows. Done that way, you will not need to look this up again, and you will be the person others ask.
Common mistakes
- Swapping the first two arguments — the delimiter comes first and ignore_empty second, not the other way around.
- Leaving ignore_empty as FALSE on data with gaps, which produces ugly doubled delimiters like "red, , blue".
- Forgetting the quotes around the delimiter, so a literal separator such as ", " is misread and the formula errors.
Frequently asked questions
How is TEXTJOIN better than CONCATENATE?
TEXTJOIN takes a whole range at once, sets the separator a single time instead of inserting it between every pair, and can skip blank cells automatically — three things CONCATENATE cannot do.
How do I stop empty cells from adding extra delimiters?
Set the second argument, ignore_empty, to TRUE. TEXTJOIN then skips blank cells entirely, so a range with gaps joins cleanly without ", ," runs.
Can TEXTJOIN use a line break as the delimiter?
Yes — use CHAR(10) as the delimiter, =TEXTJOIN(CHAR(10), TRUE, A2:A6), and turn on Wrap Text in the cell so each joined value appears on its own line.