# CONCATENATE function in Excel

> CONCATENATE joins up to 255 text items into one string.

Source: https://spreadsheetpractice.com/functions/concatenate · 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:** CONCATENATE joins up to 255 text items into one string.
- **Syntax:** `=CONCATENATE(text1, [text2], ...)`
- **Most common use:** `=CONCATENATE(A2," ",B2)` returns Maya Chen (First and last name with a space between)
- **Available in:** Every current version
- **Category:** [Text functions](https://spreadsheetpractice.com/functions/category/text)
- **Returns:** One text string.

## What it does

CONCATENATE joins up to 255 text items into one string. It works in every version of Excel, which is why older workbooks are full of it, but each cell has to be listed separately. In Excel 2019 and later, CONCAT and TEXTJOIN do the same job with less typing.

## Syntax

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

| Argument | Required? | What it is |
|---|---|---|
| `text1` | Required | The first item to join. |
| `text2` | Optional | More items, each a single cell, number or piece of text. |

## Examples

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

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=CONCATENATE(A2," ",B2)` | Maya Chen | First and last name with a space between |
| D3 | `=CONCATENATE(LEFT(A3,1),". ",B3)` | R. Patel | First initial and last name |
| D4 | `=CONCATENATE(B4," x",C4)` | Wong x4455 | Numbers join as plain digits |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | First | Last | Ext | Result |
| 2 | Maya | Chen | 4127 | Maya Chen |
| 3 | Raj | Patel | 4310 | R. Patel |
| 4 | Lee | Wong | 4455 | Wong x4455 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| A range doesn't join | CONCATENATE treats A2:C2 as separate values rather than one item, so you get several results (a spill in Microsoft 365), or a single value or #VALUE! in older versions. List the cells individually, or switch to CONCAT. |
| Words run together | CONCATENATE adds nothing between items. Put " " in as its own argument. |

## Tips

- In any version, & is shorter: =A2&" "&B2 is the same as =CONCATENATE(A2," ",B2).

## Related functions

- [CONCAT](https://spreadsheetpractice.com/functions/concat): CONCAT joins text from several cells or whole ranges into one string.
- [TEXTJOIN](https://spreadsheetpractice.com/functions/textjoin): TEXTJOIN joins a list of values with the same delimiter between each one, and can skip blanks.
- Comparison: [CONCAT vs TEXTJOIN vs &](https://spreadsheetpractice.com/functions/compare/concat-vs-textjoin)

## Questions

### Is CONCATENATE being removed from Excel?

No. It still works in every version for compatibility. Microsoft recommends CONCAT for new work, but existing formulas keep working.

### How do I CONCATENATE a range of cells?

CONCATENATE can't join a range as one item. Use =CONCAT(A2:A10) for no separator, or =TEXTJOIN(", ",TRUE,A2:A10) to put a separator between values.

## Practice

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

---

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