TEXTJOIN Function in Excel
Intermediate
Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined.
Syntax
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)Example
Use Case
Join a list of emails separated by a comma.
Common Errors to Avoid
- Not available in Excel 2013 or earlier versions
- Delimiter must be in quotes (e.g., ", " not just comma)
- Ignore_empty must be TRUE or FALSE, not 1 or 0
Pro Tips
Use ignore_empty=TRUE to automatically skip blank cells. Great for creating comma-separated lists from ranges. Can concatenate entire ranges without individual cell references.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →