CONCATENATE
Text

Joins two or more text strings into one string

Syntax:

=CONCATENATE(text1, [text2], ...)

Example:

=CONCATENATE("Hello", " ", "World")