Syntax
=CONCATENATE(string1, [string2, ...])
string1- The first value to join.
string2, ...- Optional. More values or ranges.
CONCATENATE function in Google Sheets
CONCATENATE joins several pieces of text into one. It does the same job as the & operator, so pick whichever you find easier to read.
Practice CONCATENATE
Task 1 of 3
Combine first and last name with a space between them. Answer in C2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
CONCATENATE examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Emp ID | Name | Dept | Salary | |
| 2 | 1042 | Maya Patel | Finance | maya.patel@acme.co | $72,000.00 |
| 3 | 1187 | Leo Rossi | Support | leo.rossi@acme.co | $51,000.00 |
| 4 | 1305 | Ava Kim | Sales | ava.kim@acme.co | $64,000.00 |
| 5 | 1411 | Omar Ali | Marketing | omar.ali@acme.co | $58,000.00 |
| 6 | 1520 | Hana Tanaka | Sales | hana.tanaka@acme.co | $69,000.00 |
| Formula | Result | What it shows |
|---|---|---|
=CONCATENATE(B2, " (", C2, ")") | Maya Patel (Finance) | Name with department in brackets. |
=B2 & " – " & C2 | Maya Patel – Finance | The same idea with &. |
=CONCATENATE(A2:A3) | 10421187 | Ranges are joined with no separator. |
Tips and common mistakes
- Nothing is added between items. Include spaces and punctuation yourself in quotes.
- To put a separator between every item of a range, use TEXTJOIN.
Related functions
Learning step by step? CONCATENATE is covered in Lesson 25: Combine Text (& and CONCATENATE) of the free course.