Syntax
=CONCAT(value1, value2)
value1- The first value.
value2- The second value.
CONCAT function in Google Sheets
CONCAT joins exactly two values into one piece of text. In Google Sheets it's the strict two-argument version of CONCATENATE.
Practice CONCAT
Task 1 of 1
Product codes are split across two columns. Use CONCAT to join A2 and B2 with nothing in between. 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.
CONCAT 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 |
|---|---|---|
=CONCAT(B2, C2) | Maya PatelFinance | No separator is added. |
=CONCAT("ID-", A2) | ID-1042 | Add a prefix. |
=CONCAT(B2, C2, D2) | #N/A | Three arguments is an error in Google Sheets. |
Tips and common mistakes
- If you're coming from Excel: Excel's CONCAT accepts many values and ranges, but Google Sheets' takes exactly two. Use CONCATENATE or & for more.
Related functions
Learning step by step? CONCAT is covered in Lesson 25: Combine Text (& and CONCATENATE) of the free course.