Join text from multiple cells or ranges into one string.
Syntax
CONCAT(text1, [text2], …)Arguments
text1required
The first value or range to join.
text2…optional
Additional values or ranges.
CONCAT combines values with no separator — the modern replacement for CONCATENATE. For a delimiter between items or to skip blanks, use TEXTJOIN instead. The & operator does the same job for a couple of cells.
=CONCAT(A2, " ", B2)→Jane DoeJoins first and last name with a space.
List the parts
Reference each cell or literal text to combine.
Add separators manually
Insert " " or ", " between parts, or switch to TEXTJOIN.
CONCAT is the newer function and accepts ranges; CONCATENATE is kept only for backward compatibility.