google spreadsheets add two strings

C++
CONCAT("String1", "String2")
//or
CONCATENATE("String1", "String2", "String3")
//CONCATENATE allows more than 2 strings.
Source

Also in C++: