# Joining text (Excel lesson 19 of 45)

> Glue names, labels and lists together.

Source: https://spreadsheetpractice.com/learn/joining-text · Updated October 29, 2026

- **Course:** [Excel course](https://spreadsheetpractice.com/learn), track "Text cleanup"
- **Time:** about 7 minutes, 3 graded exercises
- **Functions:** `&`, `CONCAT`, `TEXTJOIN`
- **Access:** Pro (the lesson text is free; the graded exercises need Pro)
- **Key formula:** `=A2&" "&B2`: First Last

## How it works

The ampersand `&` joins text: `=A2&" "&B2`. Put spaces and punctuation inside quotes.

`CONCAT` joins a whole range with nothing in between. `TEXTJOIN(delimiter, ignore_empty, range)` adds a separator between items and can skip blank cells.

## Syntax

| Formula | What it does |
|---|---|
| `=A2&" "&B2` | First Last |
| `=B2&", "&A2` | Last, First |
| `=TEXTJOIN(", ",TRUE,C2:C6)` | A comma-separated list |

## Watch out for

- Forget the quoted space and you get "MayaChen".
- TEXTJOIN with FALSE keeps blanks, giving doubled commas.

## The exercises

Solve them in the live grid at [Joining text](https://spreadsheetpractice.com/learn/joining-text). Each answer is graded, then re-checked on changed data so typed-in numbers don't pass.

1. **Full name.** In D2, join first and last name with a space. Fill down to D6.
2. **Directory format.** In E2, build "Last, First" (for example, Chen, Maya). Fill down to E6.
3. **One-cell list.** In G2, list every city from C2:C6 in one cell, separated by a comma and a space, skipping blanks.

Previous: [LEFT, RIGHT, MID & LEN](https://spreadsheetpractice.com/learn/left-right-mid-len) · Next: [Cleaning messy data](https://spreadsheetpractice.com/learn/cleaning-messy-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.
