delimiter - Required. Text string to insert between values (e.g., ", " for comma-space, " - " for dash, or "" for no separator).
ignore_empty - Required. TRUE to skip empty cells, FALSE to include them in the result. Use TRUE for clean lists without extra delimiters.
text1 - Required. First text value, cell reference, or range to join. Can be individual cells or entire ranges.
text2 - Optional. Optional. Additional text values or ranges. Up to 252 additional arguments allowed.
| A | B | C | |
|---|---|---|---|
| 1 | First | Middle | Last |
| 2 | John | Q | Smith |
| 3 | Sarah | Johnson | |
| 4 | Full Name | =TEXTJOIN(" ", TRUE, A2:C2) John Q Smith | |
| 5 | Full Name | =TEXTJOIN(" ", TRUE, A3:C3) Sarah Johnson |
Join cells with comma and space, skip blanks
=TEXTJOIN → "Apple, Banana, Orange"
Create semicolon-separated list for email Cc field
=TEXTJOIN → "user1@email.com; user2@email.com"
Combine year, month, day with dashes
=TEXTJOIN(2025, 01, 15) → "2025-01-15"
Each item on new line (enable wrap text)
Item1 Item2 Item3 (vertical list)
Combine address parts into properly formatted single-line addresses using this text joining function in Excel. Essential for mailing lists, shipping labels, customer databases, and CRM exports where addresses need to be consolidated from separate street, city, state, and zip columns. This function handles missing apartment numbers or suite information gracefully by skipping empty fields with ignore_empty=TRUE, ensuring you never get double commas or extra spaces in your formatted addresses. Perfect for marketing teams preparing direct mail campaigns, operations teams managing logistics, and data teams cleaning address data for import into external systems.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Street | City | State | ZIP | Full Address |
| 2 | 123 Main St | Boston | MA | 02101 | |
| 3 | Result: | =TEXTJOIN(", ", TRUE, A2:D2) 123 Main St, Boston, MA 02101 |
Generate pipe-separated or comma-separated tag lists for e-commerce product catalogs, inventory systems, and content management platforms using this text joining function in Excel. Combine product attributes, categories, features, and keywords into standardized formats required by Shopify, WooCommerce, Amazon, and other platforms. This function excels at consolidating multiple attribute columns into single importable fields, handling cases where products have varying numbers of tags without manual formatting. Critical for e-commerce managers uploading bulk product data, content teams managing taxonomies, and marketing teams organizing campaign tags across platforms.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Cat1 | Cat2 | Cat3 | Cat4 | Tag List |
| 2 | Electronics | Laptop | Gaming | RGB | |
| 3 | Result: | =TEXTJOIN(" | ", TRUE, A2:D2) Electronics | Laptop | Gaming | RGB |
❌ The Problem:
✅ Solution:
=TEXTJOIN(", ", TRUE, A1:A3)This text joining function in Excel is specifically designed for joining ranges with delimiters. It accepts entire ranges (A1:A3) instead of individual cells, automatically inserts the delimiter between values, and with ignore_empty=TRUE, skips blank cells to prevent double delimiters. Much more efficient and maintainable than nested CONCATENATE formulas.
❌ The Problem:
✅ Solution:
=TEXTJOIN(", ", TRUE, A1:A10)Use TRUE for ignore_empty parameter when your data contains blank cells. This function will skip empty cells and produce clean output without extra delimiters. Only use FALSE when you specifically need to preserve empty positions, such as maintaining exact column alignment in CSV exports.
❌ The Problem:
✅ Solution:
=TEXTJOIN(" ", TRUE, A1:A5)Avoid overlapping references in this text joining function. It joins everything you specify - if a cell appears in multiple arguments (both in a range and individually), its text will appear twice in the result. Use non-overlapping ranges and references for accurate text joining.
Master these TEXTJOIN variants:
From basics to advanced - AI generates perfect formulas instantly.