CONCAT
How to combine text in Excel: CONCAT, & and TEXTJOIN
CONCAT and the & operator join several cells or strings into a single text.
Syntax
=CONCAT(text1, [text2], ...)
- text1, ... — Text, cells or ranges to join.
Example
Formula:
=CONCAT(A2," ",B2)→ result: Aziz Karimov
The & operator
=A2&" "&B2 — a short form without a function. The result is the same as with CONCAT.
TEXTJOIN
Joins many cells with a delimiter: =TEXTJOIN(", ",TRUE,A2:A10). TRUE skips empty cells.
Numbers and dates
When joined, a date shows up as a number. Format it with TEXT: ="Date: "&TEXT(B2,"dd.mm.yyyy").
Put it into practice
Do interactive exercises on this topic in the Excel simulator.
Start exerciseFrequently asked questions
CONCATENATE is the older function and does not accept ranges. CONCAT, available in newer versions, works with ranges too.