Join text from multiple cells or ranges into one string.
Google Sheets supports CONCAT, CONCATENATE, and &. It also has JOIN and TEXTJOIN for combining ranges with a delimiter.
CONCAT(text1, [text2], …)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)Result: Jane Doe
Joins first and last name with a space.
CONCAT is the newer function and accepts ranges; CONCATENATE is kept only for backward compatibility.