How to Use TEXTJOIN in Excel
TEXTJOIN combines text from multiple cells with a delimiter. Use it to build clean labels, addresses, summaries, and client-facing strings.
Reviewed by Griddy
Updated for current Excel and Google Sheets workflows, with examples chosen to map back to real spreadsheet tasks rather than abstract formula syntax.
TEXTJOIN combines text from multiple cells and inserts a delimiter between each value. It is cleaner than chaining cells with &, especially when some fields are blank.
Use it for client labels, invoice descriptions, address blocks, task summaries, and any workflow where several fields need to become one readable string.
The syntax
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)- delimiter - the character between values, such as
", "or" - " - ignore_empty -
TRUEskips blank cells,FALSEincludes them - text1, [text2] - the cells, ranges, or text values to combine
Example:
=TEXTJOIN(", ", TRUE, A2:C2)If A2:C2 contains Acme, Retainer, and April, the result is:
Acme, Retainer, April
Example: build invoice line descriptions
Suppose an invoice workflow has these columns:
| Client | Project | Service | Month |
|---|---|---|---|
| Northstar Co | Website refresh | Design support | April |
You want one clean description for the invoice line.
Step 1. Choose the delimiter
For invoice descriptions, " - " is usually easier to scan than a comma.
Step 2. Join the fields
=TEXTJOIN(" - ", TRUE, A2:D2)The result is:
Northstar Co - Website refresh - Design support - April
Step 3. Skip blanks automatically
If the project field is blank, TRUE prevents a doubled delimiter. The formula still returns a readable string.
✦ TIP
TRUE for ignore_empty unless blank cells have a specific meaning in the final text.Use TEXTJOIN with filtered helper values
TEXTJOIN is especially useful when a sheet needs a compact summary.
If A2:A6 contains open tasks, this returns a comma-separated task list:
=TEXTJOIN(", ", TRUE, A2:A6)In a project tracker, that can turn several open action rows into one status summary. In a CRM sheet, it can combine next actions into a single account note.
Common issues
| Issue | Cause | Fix |
|---|---|---|
| Extra separators | ignore_empty is set to FALSE | Use TRUE |
| Text runs together | The delimiter is blank | Use " " or ", " |
| Formula is hard to read | Too many manual cell references | Use a range like A2:D2 |
| Result is too long | Too many fields are being joined | Use only fields needed by the reader |
The Griddy way
TEXTJOIN is useful. Building the same combined label down a few hundred rows is the annoying part.
"Create an invoice description from client, project, service type, and month, and skip any blank fields"
Griddy can add the TEXTJOIN formula, choose a readable delimiter, and fill it down across the table.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.
Use this on real templates
Turn structured rows into readable client text
TEXTJOIN helps invoices, client notes, and operating trackers convert several fields into one clean label or description.
Invoice Template
Professional invoice template with automatic subtotal, tax, and total calculations. Customise with your logo and send in minutes.
Invoice Template for Virtual Assistants
Invoice VA clients for hourly support, retainers, admin tasks, project work, reimbursable costs, and payment terms in one spreadsheet.
Invoice Template for Coaches
Invoice coaching clients for sessions, packages, retainers, workshops, deposits, and payment plans with a free spreadsheet invoice template.
CRM Lead Tracker
Track contacts, lead source, owner, next due date, and follow-up status in one lightweight CRM sheet. Keep hot opportunities and stale leads visible without paying for heavy sales software.