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"