Beginner
Text
CONCAT
Joins two or more pieces of text into one.
Compatibility: All Excel versions
Syntax
=CONCAT(text1, [text2], ...)
Example
=CONCAT(A1," ",B1)
When to Use It
Use CONCATENATE (or the newer & operator / TEXTJOIN function) to combine first and last names, or build a formatted label from several cells.