How To Combine Text From Two Cells In Excel (2026)
Excel can join the contents of two or more cells into one cell with a formula.
You can use the ampersand symbol, the CONCAT function or the TEXTJOIN function.
This guide shows the formula for each method, how to add spaces and commas, and what to do with numbers and dates.
Quick answer: combine text in Excel
| Method | Example formula | Best for |
|---|---|---|
| Ampersand (&) | =A2&" "&B2 | Joining two or three cells with a space between them |
| CONCAT | =CONCAT(A2, " Family") | Joining cells, ranges and text in one formula |
| TEXTJOIN | =TEXTJOIN(", ", TRUE, A2:A8) | Joining a range with a separator and skipping blank cells |
Microsoft says these methods work in Excel for Microsoft 365, Excel 2024, Excel 2021 and Excel 2019, and CONCAT also in Excel 2016.
Combine two cells with the ampersand
- Select the cell where you want the combined text.
- Type = and select the first cell.
- Type &, then type a space inside quotation marks: ” “.
- Type & again and select the second cell.
- Press Enter.
For cells A2 and B2 the finished formula is =A2&" "&B2.
Excel adds a space or any other text only when you put it inside quotation marks.
Combine cells with CONCAT
- Select the cell for the result.
- Type =CONCAT( and select the first cell.
- Type a comma, then add the next cell or a piece of text in quotation marks.
- Close the formula with ) and press Enter.
A formula such as =CONCAT(A2, " Family") joins the cell value and the quoted text.
Commas separate the items, and quoted text inside the formula is added to the result.
CONCAT examples
| Formula | What it does |
|---|---|
=CONCAT(B2:C8) | Joins every value in the range, row by row |
=CONCAT(B:B, C:C) | Joins every value in both full columns |
=CONCAT(C2, ", ", B2) | Reverses a name and adds a comma, such as Hauser, Andreas |
=CONCAT("Stream population for ", A2," ", A3, " is ", A4, "/mile.") | Builds a sentence from cell values and text |
A range inside CONCAT does not add separators, because the function has no delimiter option.
Combine a range with TEXTJOIN
The syntax is TEXTJOIN(delimiter, ignore_empty, text1, [text2], …).
| Argument | What it means |
|---|---|
| delimiter | The text placed between each joined value, in double quotation marks |
| ignore_empty | TRUE skips empty cells and FALSE includes them |
| text1 | The first item to join, either text or a range of cells |
| text2, … | Optional extra items, up to 252 text arguments in total |
The formula =TEXTJOIN(", ", TRUE, A2:A8) joins a list in A2:A8 into one string with commas between the values.
If ignore_empty is FALSE, blank cells appear as consecutive delimiters in the result.
With an empty delimiter, TEXTJOIN works like simple concatenation.
Combine first and last names
Suppose first names sit in column A and last names in column B, starting in row 2.
| Result you want | Formula | Separator |
|---|---|---|
| Nancy Davolio | =A2&" "&B2 | A space |
| Fuller, Andrew | =B3&", "&A3 | A comma and a space |
| Nancy Davolio | =CONCAT(A2," ",B2) | A space, using CONCAT |
Enter the formula in the first result cell and copy it down the column.
To keep only the text and drop the formulas, select the cells, then go to Home > Clipboard > Copy, then Paste > Paste Values.
Combine names with Flash Fill instead
Flash Fill detects a pattern in what you type and fills in the rest, so no formula is needed.
- Type the full name in the first empty cell, for example C2, and press Enter.
- Start typing the next full name in C3, and Excel shows a preview of the rest of the column.
- Press Enter to accept the preview.
If no preview appears, go to Data > Flash Fill or press Ctrl + E to run it manually.
Automatic Flash Fill can be switched on under Options > Advanced > Editing Options > Automatically Flash Fill, though newer versions may label the path differently.
Flash Fill works only when Excel can recognize a pattern from what you type.
CONCATENATE details if you still use it
The syntax is CONCATENATE(text1, [text2], ...), and it accepts up to 255 items with a combined total of 8,192 characters.
The ampersand returns the same result, so =A1&B1 equals =CONCATENATE(A1,B1).
Words run together unless you add a quoted space as its own argument.
A #NAME? error appears when a text argument is missing its quotation marks.
To format a number while joining it, use TEXT, as in =TEXT(A1,"$0.00"), which returns $23.50 when A1 contains 23.5.
Which method should you use?
- Use the ampersand for quick joins of two or three cells.
- Use CONCAT when the formula mixes cells, ranges and text.
- Use TEXTJOIN when you need a separator or want to skip blank cells.
Microsoft says CONCAT does not accept a delimiter or an ignore-empty argument, and it points to TEXTJOIN when you need either.
What happened to CONCATENATE?
Microsoft says CONCAT replaces the older CONCATENATE function.
CONCATENATE remains available for compatibility with earlier versions, but Microsoft says it may be removed in future versions.
For new workbooks, use CONCAT, TEXTJOIN or the ampersand instead.
Combine text with numbers
When you join a number to text, the result is text, so you can no longer use it in math.
Excel uses the cell’s underlying value, not what it displays, so a cell showing 40% holds 0.4.
Use the TEXT function inside the formula to control how the number appears in the result.
If you only want text to appear next to a number without changing it, use a custom number format instead.
| Format code | What it shows |
|---|---|
"Product # " 0 | 12 appears as Product #12 and stays a number |
h:mm AM/PM "EST" | A time followed by the label EST |
$0.00 "Surplus";$-0.00 "Shortage" | Surplus for zero or positive values, Shortage for negative ones |
Microsoft explains that custom number formats change only the display, so sorting and math still work on the stored value.
Limits and errors
| Function | Limit |
|---|---|
| CONCAT | Up to 253 text arguments |
| TEXTJOIN | Up to 252 text arguments |
| CONCATENATE | Up to 255 items and 8,192 characters in total |
| CONCAT and TEXTJOIN | A result longer than 32,767 characters returns the #VALUE! error |
Related Excel guides
To do the opposite and divide one cell into several, see how to split text into columns in Excel.
If joined numbers behave strangely, read how to convert numbers stored as text and how to fix #N/A, #VALUE! and #REF! errors.
Official sources: Combine text from two or more cells, TEXTJOIN function, CONCAT function and Combine text and numbers.