Excel practice › Excel functions › CONCAT and &
CONCAT and & in Excel: join text from several cells
CONCAT and the & operator join values into one text. With a first name in A2 and a last name in B2, =A2&" "&B2 gives Dana Whitfield, and so does =CONCAT(A2," ",B2).
Neither adds anything between the pieces: every space, comma or dash is yours to put in, in quotes. And dates and numbers join as the raw value the cell stores, not the way the cell shows it: a date turns into a number like 46090 unless you wrap it in TEXT.
Syntax
=CONCAT(text1, [text2], …) or =text1 & text2
text1- The first thing to join: text in quotes, a cell, or a range of cells.
[text2], …- More things to join, in the order you list them. Microsoft's limit is 253 text arguments.
&- The operator that joins the value on its left to the value on its right:
=A2&B2. It gives the same result as CONCAT with those two arguments.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First | Last | City | State | Hired | Quota | Full name |
| 2 | Dana | Whitfield | Tulsa | OK | 3/9/2026 | 48500 | Dana Whitfield |
| 3 | Marcus | Oyelaran | Boise | ID | 1/12/2026 | 52000 | |
| 4 | Irene | Kowalczyk | Fresno | CA | 2/2/2026 | 61250 | |
| 5 | Tobias | Reyes | Macon | GA | 4/20/2026 | 45000 | |
| 6 | Priya | Venkat | Akron | OH | 5/18/2026 | 57500 |
=CONCAT(A2," ",B2) for the same result, or to =C2&", "&D2 for the city and state.How Excel reads it
- It takes the pieces from left to right and glues them together exactly as they are.
- Text you type goes in double quotes:
" "is a space,", "is a comma and a space. Cell addresses take no quotes. - A separator is a piece like any other. Leave it out and the two values touch.
The result is text, also when every piece was a number.
The two ways it goes wrong
Both are live below. Fix the formula in the box and watch the cell.
1. Nothing between the pieces. CONCAT accepts a range, which is quick to write, but it has no argument for a separator:
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First | Last | City | State | Hired | Quota | Full name |
| 2 | Dana | Whitfield | Tulsa | OK | 3/9/2026 | 48500 | DanaWhitfield |
| 3 | Marcus | Oyelaran | Boise | ID | 1/12/2026 | 52000 | |
| 4 | Irene | Kowalczyk | Fresno | CA | 2/2/2026 | 61250 | |
| 5 | Tobias | Reyes | Macon | GA | 4/20/2026 | 45000 | |
| 6 | Priya | Venkat | Akron | OH | 5/18/2026 | 57500 |
=CONCAT(A2," ",B2). To join a whole range with a separator, Excel has TEXTJOIN: =TEXTJOIN(" ",TRUE,A2:B2). The sheets on this page don't run TEXTJOIN.2. A date or a number loses its format. A join uses what the cell stores, not what it shows. A date is stored as a serial number, so this is what comes out:
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First | Last | City | State | Hired | Quota | Note |
| 2 | Dana | Whitfield | Tulsa | OK | 3/9/2026 | 48500 | Hired 46090 |
| 3 | Marcus | Oyelaran | Boise | ID | 1/12/2026 | 52000 | |
| 4 | Irene | Kowalczyk | Fresno | CA | 2/2/2026 | 61250 | |
| 5 | Tobias | Reyes | Macon | GA | 4/20/2026 | 45000 | |
| 6 | Priya | Venkat | Akron | OH | 5/18/2026 | 57500 |
="Hired "&TEXT(E2,"mmm d, yyyy") gives Hired Mar 9, 2026.Numbers behave the same way. A cell formatted as currency shows $48,500 and joins as 48500; a cell that shows 40% joins as 0.4. TEXT puts the format back: ="Quota: "&TEXT(F2,"$#,##0") gives Quota: $48,500.
Practice: 3 exercises
Type the formula in the box, press Enter. Clicking a cell inserts its address. Each answer is checked on the data you see and again on changed data, so a typed-in value won't pass.
For a sorted contact list: in G2, build the name in the form Whitfield, Dana from the last name in B2 and the first name in A2.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First | Last | City | State | Hired | Quota | Sort name |
| 2 | Dana | Whitfield | Tulsa | OK | 3/9/2026 | 48500 | |
| 3 | Marcus | Oyelaran | Boise | ID | 1/12/2026 | 52000 | |
| 4 | Irene | Kowalczyk | Fresno | CA | 2/2/2026 | 61250 | |
| 5 | Tobias | Reyes | Macon | GA | 4/20/2026 | 45000 | |
| 6 | Priya | Venkat | Akron | OH | 5/18/2026 | 57500 |
Show the answer
=B2&", "&A2 gives Whitfield, Dana.
Three pieces: the last name, a comma and a space in quotes, the first name. =CONCAT(B2,", ",A2) is the same formula written with the function.
For name badges: in G2, build the first name, a space, the first letter of the last name and a period, like Dana W.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First | Last | City | State | Hired | Quota | Badge |
| 2 | Dana | Whitfield | Tulsa | OK | 3/9/2026 | 48500 | |
| 3 | Marcus | Oyelaran | Boise | ID | 1/12/2026 | 52000 | |
| 4 | Irene | Kowalczyk | Fresno | CA | 2/2/2026 | 61250 | |
| 5 | Tobias | Reyes | Macon | GA | 4/20/2026 | 45000 | |
| 6 | Priya | Venkat | Akron | OH | 5/18/2026 | 57500 |
Show the answer
=A2&" "&LEFT(B2,1)&"." gives Dana W..
LEFT(B2,1) returns the first letter of the last name, and the period is one more piece in quotes. Functions and quoted text can be mixed freely in a join.
For a welcome note: in G2, build Dana Whitfield, hired Mar 9, 2026 from A2, B2 and the date in E2. The date's format code is "mmm d, yyyy".
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First | Last | City | State | Hired | Quota | Note |
| 2 | Dana | Whitfield | Tulsa | OK | 3/9/2026 | 48500 | |
| 3 | Marcus | Oyelaran | Boise | ID | 1/12/2026 | 52000 | |
| 4 | Irene | Kowalczyk | Fresno | CA | 2/2/2026 | 61250 | |
| 5 | Tobias | Reyes | Macon | GA | 4/20/2026 | 45000 | |
| 6 | Priya | Venkat | Akron | OH | 5/18/2026 | 57500 |
Show the answer
=A2&" "&B2&", hired "&TEXT(E2,"mmm d, yyyy") gives Dana Whitfield, hired Mar 9, 2026.
TEXT turns the date into the text Mar 9, 2026 before it's joined. Without it, the join would use what the cell stores: 46090.
Questions people ask
What is the difference between CONCAT, CONCATENATE and &?
They all join text. CONCAT is the newer function: it replaces CONCATENATE and also accepts ranges like A2:C2. CONCATENATE is still there for compatibility with older workbooks. & is the operator form: =A2&" "&B2 and =CONCAT(A2," ",B2) give the same result.
How do I add a space or a comma between two cells?
Put it in the formula as its own piece, in double quotes: =A2&" "&B2 for a space, =B2&", "&A2 for a comma and a space. Excel adds nothing by itself.
How do I join a whole range with commas?
CONCAT can't: it has no separator argument. Use TEXTJOIN, which takes the separator first: =TEXTJOIN(", ",TRUE,A2:A8). The TRUE tells it to skip empty cells.
Why does a date turn into a number when I join it to text?
Because a date is stored as a serial number, and a join uses the stored value, not the format the cell shows. Wrap the date in TEXT with the format you want: =A2&" "&TEXT(B2,"mm/dd/yy").