concatenate string in formula google spreadsheet code example
Example: google spreadsheets add two strings
CONCAT("String1", "String2")
//or
CONCATENATE("String1", "String2", "String3")
//CONCATENATE allows more than 2 strings.
CONCAT("String1", "String2")
//or
CONCATENATE("String1", "String2", "String3")
//CONCATENATE allows more than 2 strings.