Google Sheets function
CONCATENATE function in Google Sheets
CONCATENATE in Google Sheets joins two or more strings into one text value. It does not add separators automatically, so spaces and punctuation must be supplied as arguments. Use CONCATENATE to combine names, identifiers, labels, or other short pieces of text.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=CONCATENATE(string1, [string2, ...])Arguments
| Argument | Required | What it means |
|---|---|---|
string1 | Yes | The first string or value to join. |
string2, ... | No | Additional strings or values to join in order. |
Examples
Combine a first and last name
| A | B | |
|---|---|---|
| 1 | First name | Last name |
| 2 | Ava | Chen |
=CONCATENATE(A2," ",B2)Result: Ava Chen
The formula joins the first name, a space, and the last name in that order.
Common mistakes
Expecting spaces to appear between arguments automatically.
Add each required space or separator as its own text argument.
Using CONCATENATE for a long range that needs one delimiter.
Use TEXTJOIN to combine a range with a consistent delimiter.