Resources > Formula Help
How Do I Use TEXTJOIN in Excel?
Last Updated: June 2026
Quick Answer
TEXTJOIN combines text from multiple cells using a delimiter such as a space, comma, or dash.
=TEXTJOIN(", ",TRUE,A2:A10)
TEXTJOIN Syntax
=TEXTJOIN(delimiter, ignore_empty, text1, [text2])
- delimiter: what goes between each value
- ignore_empty: TRUE ignores blank cells
- text1: the range or value to combine
Example
=TEXTJOIN(" - ",TRUE,A2:C2)
This combines values from A2 through C2 separated by dashes.
When to Use TEXTJOIN
- Combining names
- Creating labels
- Building comma-separated lists
- Joining data from multiple cells
