Skip to content

Excel function · Text

Excel CONCATENATE function

CONCATENATE joins the texts and cells you give it, one after the other, into a single text: first and last names into a full name, or a series, a year and a sequence number into a document number.

In Turkish Excel: BİRLEŞTİR

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

English Excel=CONCATENATE(text1, [text2], ...)
Turkish Excel=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

ArgumentRequiredDescription
text1RequiredThe first piece to join: a cell, text in quotes or a number.
text2OptionalThe 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.

C2fx=CONCATENATE(A2," ",B2)
Join first and last names: example table
ABC
1First NameLast NameFull Name
2EmmaBrownEmma Brown
3Mary AnnClarkMary Ann Clark
4LucasGrayLucas Gray
5AvaThompsonAva 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.

D2fx=CONCATENATE(A2,"-",B2,"-",TEXT(C2,"0000"))
Build a document number from series, year and sequence: example table
ABCD
1SeriesYearSeqDocument No
2INV202542INV-2025-0042
3INV2025117INV-2025-0117
4RTN20257RTN-2025-0007
5PO20251130PO-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.

C2fx=CONCATENATE(A2,": ",TEXT(B2,"0%")," of target")
Write a percentage into a sentence with its format: example table
ABC
1RepAchievedReport Line
2Emma92%Emma: 92% of target
3Liam108%Liam: 108% of target
4Olivia76%Olivia: 76% of target
5Noah60%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

Type this in Nexell

Join the First Name and Last Name columns into a Full Name column with a space in between

Convert to table

Bring 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.

Related functions

All text functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free