What is CONCATENATE?
Joins multiple text strings into one. While TEXTJOIN is newer, CONCATENATE remains widely used for combining cell contents.
Syntax
=CONCATENATE(text1, [text2], ...)
Example
Formula: =CONCATENATE(A1, \
Result: John Smith
How It Works
Combines text from multiple cells. If A1='John' and B1='Smith', with a space between them, result is 'John Smith'. You can also use the & operator as shorthand.