CONCAT
The CONCAT function joins text strings into one text string.
Syntax
=CONCAT(text1, [text2], ...)
Parameters
text1: First text string to jointext2, ...: Additional text strings to join (optional)
Examples
=CONCAT("Hello", " ", "World") // Returns "Hello World"
=CONCAT("A", "B", "C") // Returns "ABC"