How to combine text in Excel
To combine text in Excel, join the cells with the & operator, for example =A2&" "&B2, or use TEXTJOIN to join a whole range with a separator. All three methods return text, and you choose which one fits by how many cells you join and whether some may be empty.
This guide shows each method with a worked example, then how to mix text with numbers and dates. The lessons at the end let you practice on real data.
1. Join cells with the & operator
The ampersand glues text together. Put a space or any other text in quotation marks between the cells, because Excel adds nothing by itself. The & operator works in every version of Excel and is the shortest option for two or three cells.
Example: First name and last name
| A | B | C | |
|---|---|---|---|
| 1 | First | Last | Full name |
| 2 | Ana | Cohen | Ana Cohen |
The formula joins A2, a space in quotation marks, and B2: Ana Cohen.
2. Join a range with TEXTJOIN
TEXTJOIN takes a separator, a TRUE or FALSE that tells it to skip empty cells, and then the cells or the whole range. It saves you from typing & between ten cells, and with TRUE it avoids a doubled comma where a cell is blank. It is available in Excel 2019 and later and in Microsoft 365.
Example: An address with a missing part
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Street | City | Address |
| 2 | Ana | Tel Aviv | Ana, Tel Aviv |
B2 is empty, and TRUE tells TEXTJOIN to skip it, so there is only one comma between the two parts.
3. CONCATENATE and CONCAT
CONCATENATE joins the cells you list, one argument per cell: =CONCATENATE(A2," ",B2). It is the older function and still works everywhere. CONCAT is its newer replacement and also accepts a range, but neither one adds a separator. For new work, prefer & or TEXTJOIN.
4. Combine text with numbers and dates
When you join a number to text, Excel uses the plain value, so a price shown as 1,234.50 turns into 1234.5, and a date turns into a serial number such as 45731. Wrap the value in TEXT with the format you want to see.
Example: A sentence with a formatted amount
| A | B | C | |
|---|---|---|---|
| 1 | Name | Amount | Sentence |
| 2 | Ana | 1234.5 | Ana paid 1234.50 |
TEXT turns 1234.5 into the text 1234.50 with two decimals, and & joins it to the rest.
5. Turn formulas into plain text
The joined column is a formula, so deleting the source columns breaks it. To keep the result, copy the column and use Paste Special > Values. After that you can delete the original columns safely.
Common mistakes
No space between the words. =A2&B2 returns AnaCohen.
Fix: Add the separator in quotation marks: =A2&" "&B2.
A date shows as a number. Joining a date cell gives a number like 45731.
Fix: Wrap it in TEXT, for example TEXT(B2,"dd/mm/yyyy").
Extra commas for empty cells. Joining with & leaves a separator for every blank cell.
Fix: Use TEXTJOIN with TRUE as the second argument so blank cells are skipped.
Frequently asked questions
How do I put a line break between the joined cells?
Use the line-feed character as the separator, written as CHAR(10), and switch on Wrap Text for the cell.
What is the difference between CONCAT and CONCATENATE?
CONCATENATE needs every cell as its own argument. CONCAT accepts a range as well. Neither adds a separator, which is why TEXTJOIN is usually the better choice.
Can I combine text in the other direction, splitting it?
Yes, see the guide on splitting text, which covers Text to Columns, Flash Fill and formulas.
Related functions
- TEXTJOINTEXTJOIN joins the text from a range with a separator such as a comma, and can skip empty cells.
- CONCATENATECONCATENATE, CONCAT and the & operator join text from several cells into one, like first and last name.
- TEXTTEXT turns a number or date into text in the format you choose, such as 2 decimals, 12,500 or 2026-03-18.
- TRIMTRIM removes extra spaces from text: at the start, at the end, and doubles between words.
More on combining text
The guide shows the three ways to join text. This piece adds how to build readable labels from several cells, how to keep numbers and dates looking right inside a sentence, and how to start a new line inside one cell.
Build labels people can read
Joining is most useful for labels, such as a name tag, an invoice line or a chart title. Decide the separator first, because it shapes everything: a space for names, a comma and a space for addresses, a dash for codes. With TEXTJOIN you write that separator once, instead of repeating it between every cell.
=A2&" - "&B2
=TEXTJOIN(" | ",TRUE,A2:D2)Numbers and dates inside a sentence
A joined number loses its cell format. A price shown as 1,234.50 comes out as 1234.5, and a date comes out as a five-digit serial number. Wrap the value in TEXT and give it the format you want to see. The format codes are the same as in the Format Cells dialog: 0.00 for two decimals, #,##0 for thousands separators, 0% for a percent and dd/mm/yyyy for a date.
="Total: "&TEXT(B2,"#,##0.00")
="Due on "&TEXT(C2,"dd/mm/yyyy")A new line inside one cell
To put each part on its own line, join the parts with the line-feed character, which you write as CHAR(10), and switch on Wrap Text for the cell. Without Wrap Text the cell shows everything on one line and the break looks like it is missing. This is handy for address labels built from separate street, city and postal code columns.
When the joined result is final, copy it and paste it as values, so that it no longer depends on the source cells. For the opposite job, taking text apart, read [how to split text](/guides/split-text-in-excel), or practice both in [the text lessons](/learn/text-clean-join).