What it does
Each piece goes into CONCATENATE as a separate argument, and Excel joins them with nothing in between. If you want a space, comma or hyphen, add it as its own piece in quotes: =CONCATENATE(A2," ",B2). The & operator does the same: =A2&" "&B2.
Numbers and dates are joined without their formatting: a rate shown as 85% comes out as 0.85 and a date as its serial number. To keep the look, convert the value to text with TEXT before joining. CONCATENATE does not accept ranges; A2:C2 does not join the three cells into one text.
CONCATENATE is kept for compatibility. In Excel 2019 and Microsoft 365, CONCAT also accepts ranges, and TEXTJOIN is much shorter when you want the same delimiter between every value and empty cells skipped.
Syntax
=CONCATENATE(text1, [text2], ...)=BİRLEŞTİR(metin1; [metin2]; ...)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
text1 | Required | The first piece to join: a cell, text in quotes or a number. |
text2 | Optional | The following pieces, up to 255 in total. If you need a space between them, add " " as a separate piece. |
Examples
1Join first and last names
First and last names are in separate columns. To get a space between them, " " is added as a piece of its own.
=CONCATENATE(A2," ",B2)| A | B | C | |
|---|---|---|---|
| 1 | First Name | Last Name | Full Name |
| 2 | Emma | Brown | Emma Brown |
| 3 | Mary Ann | Clark | Mary Ann Clark |
| 4 | Lucas | Gray | Lucas Gray |
| 5 | Ava | Thompson | Ava Thompson |
- C2 (filled down to C5)
=CONCATENATE(A2," ",B2)
C2 shows Emma Brown and C3 shows Mary Ann Clark. =A2&" "&B2 gives the same result.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Build a document number from series, year and sequence
The sequence is stored as a number such as 42, but it should show four digits in the document number. TEXT turns the number into text like "0042", and CONCATENATE joins the pieces with hyphens.
=CONCATENATE(A2,"-",B2,"-",TEXT(C2,"0000"))| A | B | C | D | |
|---|---|---|---|---|
| 1 | Series | Year | Seq | Document No |
| 2 | INV | 2025 | 42 | INV-2025-0042 |
| 3 | INV | 2025 | 117 | INV-2025-0117 |
| 4 | RTN | 2025 | 7 | RTN-2025-0007 |
| 5 | PO | 2025 | 1130 | PO-2025-1130 |
- D2 (filled down to D5)
=CONCATENATE(A2,"-",B2,"-",TEXT(C2,"0000"))
D2 shows INV-2025-0042 and D4 shows RTN-2025-0007. 1130 already has four digits, so it is written as is: PO-2025-1130.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
3Write a percentage into a sentence with its format
The rates in column B are shown as percentages, but they hold values such as 0.92. To appear with a percent sign in the sentence, they are first converted with TEXT and the "0%" format.
=CONCATENATE(A2,": ",TEXT(B2,"0%")," of target")| A | B | C | |
|---|---|---|---|
| 1 | Rep | Achieved | Report Line |
| 2 | Emma | 92% | Emma: 92% of target |
| 3 | Liam | 108% | Liam: 108% of target |
| 4 | Olivia | 76% | Olivia: 76% of target |
| 5 | Noah | 60% | Noah: 60% of target |
- C2 (filled down to C5)
=CONCATENATE(A2,": ",TEXT(B2,"0%")," of target")
C2 shows Emma: 92% of target and C4 shows Olivia: 76% of target; 0.755 is rounded for display. Without TEXT, the rate would be written as 0.92.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- Words run together
Cause: No delimiter was added between the pieces, so "Emma" and "Brown" become "EmmaBrown".
Fix: Add the delimiter as its own piece:
=CONCATENATE(A2," ",B2).- Formatting is lost
Cause: Numbers, percentages and dates are joined using their stored values, not the way the cell shows them.
Fix: Format the value with TEXT first:
=CONCATENATE("Rate: ",TEXT(B2,"0%")).- #N/A
Cause: One of the joined cells contains an error such as #N/A, and CONCATENATE passes it on.
Fix: Wrap the faulty piece in IFERROR or fix the error at its source.
Good to know
- To add a line break, put
CHAR(10)between the pieces and turn on Wrap Text for the cell. - If you may need to split the joined text again later, choose a consistent delimiter; TEXTSPLIT or TEXTBEFORE can then take it apart easily.
In Nexell
Get Nexell to do it from a sentence
Join the First Name and Last Name columns into a Full Name column with a space in between
Convert to tableBring your list into the tool and type this. Nexell builds the new column with a real Excel join formula and shows it in the preview first; in the downloaded file, the full name changes when either part changes.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
Is there a difference between CONCATENATE and &?
The result is the same. & is shorter to type; some people find CONCATENATE easier to read in long formulas because the pieces are separated by commas.
How do I add a line break when joining text?
Put CHAR(10) between the pieces and turn on Wrap Text: =CONCATENATE(A2,CHAR(10),B2). Without Wrap Text, the two pieces appear side by side.