Quick Navigation
TEXTJOIN Function
Summary
The TEXTJOIN function elegantly combines multiple text strings or ranges into a single text value using a customizable delimiter. It automatically skips empty cells when specified, making it perfect for clean data consolidation from lists, tables, or dynamic ranges.
Syntax
TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| delimiter | Text |
Yes | Separator between values (text, empty string, or cell reference) |
| ignore_empty | Boolean |
Yes | TRUE ignores empty cells, FALSE includes them |
| text1 | Text/Range |
Yes | Required first text item or range |
| [text2,...] | Text/Range |
No | Optional additional text items/ranges |
Using the TEXTJOIN Function
TEXTJOIN revolutionizes text consolidation in Excel by replacing lengthy CONCATENATE formulas and manual joining operations. Use it to create comma-separated lists, pipe-delimited exports, or any structured text output from scattered data sources.
Common TEXTJOIN Examples
Create Comma-Separated Currency List
=TEXTJOIN(", ", TRUE, A2:A8)Joins currency names from A2:A8 into: 'US Dollar, Australian Dollar, Chinese Yuan...'
Join Table Data with Custom Delimiter
=TEXTJOIN(", ", TRUE, A2:B8)Combines all non-empty cells from range into comma-separated list, skipping blanks
Dynamic Row Delimiter from Cells
=TEXTJOIN(A8:D8, TRUE, A2:D7)Uses cell contents as delimiters for complex record formatting: 'Tulsa,OK,74133,US;'
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Resulting string exceeds 32,767 character limit
Solution: Reduce input range size or use shorter delimiters
#VALUE! with numbers
Cause: Delimiter provided as number instead of text
Solution: Enclose numbers in quotes or reference text cells
Unexpected empty results
Cause: ignore_empty=TRUE skipping all values
Solution: Check if all input cells contain data or set ignore_empty=FALSE
Notes
- Available only in Excel 2019 and Microsoft 365
- Maximum 252 text arguments total
- Empty delimiter effectively works like CONCAT function
- Numbers convert to text automatically
- Perfect for CSV-style data exports
Compatibility
Available in: Excel 2019, Microsoft 365
Not available in: Excel 2016 and earlier, Excel for Web (limited)
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2019, Microsoft 365