CONCATENATE
Returns the strings appended to one another.
Usage examples
CONCATENATE("a", "b", "c")
Syntax
CONCATENATE ( value1, [ value2, ... ] )
-
value1- any string expression. -
value2- any string expression.
Returns
string - the string appended to one another.