How it works.
TEXTJOIN is the modern formula for combining text strings. It lets you specify a delimiter (like a comma, space, or hyphen) to place between values, and has a built-in option to automatically skip empty cells.
💡 In simple terms.
Glues text from different cells together into one cell, placing a separator of your choice (like a comma) in between.
Analogy
"Think of this like threading letter beads on a necklace. You choose a separator (like a space or comma) to put between each bead (word)."
Syntax guide.
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
Parameters
delimiterRequired
The character(s) to place between each item.
ignore_emptyRequired
TRUE = Skip empty cells, FALSE = Include empty cells in output.
Default: TRUEtext1Required
The first cell range or text item to combine.
Interactive formula builder.
Fill in the input arguments below to construct your custom formula string. Copy it directly to paste into your Excel spreadsheets.
Generated Output
Best Practices
- TEXTJOIN can combine an entire range of cells (e.g. A2:A50) in a single argument, which was impossible with CONCATENATE.
- It is extremely useful for building formatted lists, joining address fields, or creating CSV rows.
Common Gotchas
- Excel caps formula return text length at 32,767 characters. Joining thousands of cells may trigger a #VALUE! error.