How to Use TEXTJOIN in Excel

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

• delimiter - the character between values, such as ", " or " - "
• ignore_empty - TRUE skips blank cells, FALSE includes them
• text1, [text2] - the cells, ranges, or text values to combine

Example:

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:

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

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.

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:

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

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.

Clean inputs before joining

TEXTJOIN is most reliable when every source cell has a predictable meaning. Use TRUE for ignore_empty when blank cells should not create repeated delimiters, but do not treat a blank as automatically equivalent to missing data. A blank department, apartment number, or optional address line may need a separate review rule.

For imported data, clean each component before combining it. TRIM removes repeated ordinary spaces, and CLEAN removes many non-printing characters. Then join the cleaned columns with a delimiter that will remain readable when the output is copied elsewhere:

Keep the original fields alongside the combined label. That preserves the ability to correct one component later instead of parsing a finished string back into columns.

Sources

• Microsoft Support: TEXTJOIN function
• Microsoft Support: CONCAT function