The CONCATENATE function
Joining pieces of text into one. The & operator does the same, shorter; TEXTJOIN does it better.
Syntax
=CONCATENATE(text1, [text2], …)
In a French Excel: =CONCATENER(texte1; [texte2]; …).
Arguments
- text1, text2…: texts, cells or numbers; no ranges.
An example
=CONCATENATE(B2," ",C2)
First and last names separated by a space; the same as =B2&" "&C2.
Pitfalls
- A date joins as a number (45567): TEXT first.
- No ranges:
A2:C2is not accepted; CONCAT or TEXTJOIN, yes.
Going further
- TEXTJOIN, with a separator.
- Split or merge columns.
Frequently asked questions
- CONCATENATE or CONCAT?
- CONCAT (Excel 2019 and later) accepts ranges; CONCATENATE is kept for compatibility.