concatenate google sheets code example

Example 1: google spreadsheets add two strings

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

Example 2: google sheets concatenate

CONCATENATE("Welcome", " ", "to", " ", "Sheets!")

CONCATENATE(A1,A2,A3)

CONCATENATE(A2:B7)