Why you need this
Combines text from multiple ranges/strings, including a delimiter. Ignores empty cells automatically.
One-Click Copy
=TEXTJOIN(delimiter, ignore_empty, text1, ...)
Copy
Quick context
- • Works in both Excel and Google Sheets.
- • Use when you need consistent, auditable results.
- • Copy the snippet above and adjust only the ranges.
When to use
Learn how to use the Excel TEXTJOIN Formula.
Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.
Common Mistakes
- ✕ Not handling empty cells. If your data contains blanks, failing to set the second argument to TRUE results in ugly repeated delimiters (e.g., 'Apple,,Banana').
Best Practices
- ✓ Use TRUE to ignore empty cells. This creates clean lists without holes or double-commas.
- ✓ Create CSVs. TEXTJOIN is the best way to quickly concatenate a column of values into a comma-separated list for SQL queries or emails.
Scalability Warning
TEXTJOIN is great, but database exports are better for cleaning data.
See data Alternatives