Google Sheets Function: CONCATENATE

The CONCATENATE function combines multiple values into one.


=CONCATENATE(value_1, value_2, value_3, etc)

Usage Example

The CONCATENATE function here should return a sentence containing text as well as the values from cells A and B:

google sheets concatenate function

Enter the different values separated by , into the function:

=CONCATENATE(A2," has ",B2," child(ren)")
google sheets concatenate function values
You can also use & to replace the CONCATENATE function.