google sheets concat with space code example

Example: google spreadsheets add two strings

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