Google Sheets Function: CONCATENATE
The CONCATENATE function combines multiple values into one.
Usage:
=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:
Enter the different values separated by ,
into the function:
=CONCATENATE(A2," has ",B2," child(ren)")
You can also use & to replace the CONCATENATE function.