google spreadsheets add two strings 1

google spreadsheets add two strings

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

Here is what the above code is Doing:
1. We create a new column called “Full Name” and set it equal to the concatenation of the “First Name” and “Last Name” columns.
2. We create a new column called “Full Address” and set it equal to the concatenation of the “Address”, “City”, “State”, and “ZIP Code” columns.

Similar Posts