# CONCAT function in Excel

> CONCAT joins text from several cells or whole ranges into one string.

Source: https://spreadsheetpractice.com/functions/concat · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** CONCAT joins text from several cells or whole ranges into one string.
- **Syntax:** `=CONCAT(text1, [text2], ...)`
- **Most common use:** `=CONCAT(A2," ",B2)` returns Maya Chen (First and last name with a space between)
- **Available in:** Excel 2019 and later, including Microsoft 365
- **Category:** [Text functions](https://spreadsheetpractice.com/functions/category/text)
- **Returns:** One text string. Numbers are joined as stored, without formatting.
- **Google Sheets:** Google Sheets has CONCAT, but it joins only two values. Use CONCATENATE or TEXTJOIN there.

## What it does

CONCAT joins text from several cells or whole ranges into one string. It replaced CONCATENATE in Excel 2019 and adds one improvement: you can pass a range like A2:C2 instead of listing every cell.

## Syntax

`=CONCAT(text1, [text2], ...)`

| Argument | Required? | What it is |
|---|---|---|
| `text1` | Required | The first item to join: text, a cell or a range. |
| `text2` | Optional | More items to join, up to 253 in total. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=CONCAT(A2," ",B2)` | Maya Chen | First and last name with a space between |
| D3 | `=CONCAT(A3:C3)` | RajPatelFargo | A whole range joined with no separator |
| D4 | `=CONCAT(B4,", ",A4," (",C4,")")` | Wong, Lee (Rochester) | Cells and typed text mixed together |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | First | Last | City | Result |
| 2 | Maya | Chen | Duluth | Maya Chen |
| 3 | Raj | Patel | Fargo | RajPatelFargo |
| 4 | Lee | Wong | Rochester | Wong, Lee (Rochester) |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| No separator between values | CONCAT(A2:C2) runs the values together. Add separators as their own items, or use TEXTJOIN, which puts a delimiter between every item. |
| Numbers lose their formatting | CONCAT("Total: ",B2) shows 1250, not $1,250.00. Format inside the formula: CONCAT("Total: ",TEXT(B2,"$#,##0.00")). |
| #NAME? in older versions | CONCAT isn't in Excel 2016 or earlier. Use CONCATENATE or the & operator there. |

## Tips

- For two or three cells, the & operator is just as good: =A2&" "&B2.

## Related functions

- [TEXTJOIN](https://spreadsheetpractice.com/functions/textjoin): TEXTJOIN joins a list of values with the same delimiter between each one, and can skip blanks.
- [CONCATENATE](https://spreadsheetpractice.com/functions/concatenate): CONCATENATE joins up to 255 text items into one string.
- Comparison: [CONCAT vs TEXTJOIN vs &](https://spreadsheetpractice.com/functions/compare/concat-vs-textjoin)

## Questions

### What is the difference between CONCAT and CONCATENATE?

CONCAT accepts ranges, so =CONCAT(A2:D2) works, while CONCATENATE needs every cell listed separately. CONCATENATE still works for compatibility; CONCAT is its replacement.

### How do I concatenate with a space?

Add the space as its own item: =CONCAT(A2," ",B2). To put a space between every value in a range, use =TEXTJOIN(" ",TRUE,A2:D2).

## Practice

A graded CONCAT exercise ("Build SKUs") is on [the CONCAT page](https://spreadsheetpractice.com/functions/concat). It is checked instantly, then re-checked on changed data.

Lessons that use CONCAT:

- [Lesson 19: Joining text](https://spreadsheetpractice.com/learn/joining-text) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
