Google Sheets

Google Sheets Concatenate

Use CONCATENATE, ampersands, and TEXTJOIN in Google Sheets to combine names, labels, IDs, addresses, notes, and review text cleanly.

June 16, 2026/5 min read

Concatenate in Google Sheets means combining values from multiple cells into one text string. It is useful for names, labels, invoice descriptions, CRM summaries, campaign IDs, addresses, and readable notes built from structured columns.

Use concatenation when the source fields should stay separate but the output needs to be readable.

The syntax

Google Sheets gives you several ways to combine text:

=CONCATENATE(text1, text2, ...)

=A2&" "&B2

=TEXTJOIN(" ", TRUE, A2:C2)

CONCATENATE joins each value you pass to it
& is often faster for simple formulas
TEXTJOIN is better when you need a delimiter and blank-cell handling

Combine first and last name

If first name is in A2 and last name is in B2, combine them with a space:

=A2&" "&B2

That pattern is common in a CRM lead tracker where the sheet keeps first and last names separate for sorting or imports but needs a full-name display field for review.

Build an invoice line description

If service type is in A2, project is in B2, and period is in C2, you can create a readable invoice description:

=TEXTJOIN(" - ", TRUE, A2:C2)

This produces a cleaner line item for an invoice template without forcing the billing sheet to store every detail in one cell.

Add labels around values

Concatenation can also create summary text:

="Owner: "&B2&" | Stage: "&C2&" | Next: "&D2

That is useful in sales, project, and content workflows where a compact review label needs to pull from several fields.

TIP

Keep the original fields separate. Concatenated text should usually be an output, not the only place the data exists.

CONCATENATE vs TEXTJOIN

Need	Better option
Join two cells quickly	`&`
Join several known cells	`CONCATENATE`
Add the same delimiter between fields	`TEXTJOIN`
Ignore blank cells	`TEXTJOIN`
Build a custom sentence	`&`

Common concatenate mistakes

Problem	Why it happens	Fix
Words run together	Spaces were not added manually	Add `" "` or another delimiter
Blank fields leave extra separators	Formula always adds delimiters	Use `TEXTJOIN` with ignore blanks set to TRUE
Dates show as serial numbers	Raw date value is joined as a number	Wrap the date in `TEXT()`
Source data becomes hard to filter	Everything was merged into one field	Keep structured columns and create a display field

The Griddy way

Concatenation is tedious when the output needs punctuation, date formatting, blank handling, and readable labels.

"Create a clean summary column from owner, status, due date, and next action, but skip blanks and format the date normally"

Griddy can build the formula, preserve the source columns, and make the joined text readable enough for weekly review.

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.

Excel Plugin Sheets Plugin

Use this on real templates

Turn structured fields into readable labels

Concatenation helps CRM, pipeline, invoice, and planning sheets create clean display text without losing the source fields behind it.

Sales

All posts