Concatenating Multiple Values with Google Sheets

To concatenate text, values from other cells, or functions within a cell, use & to assemble the different elements.

For example, to concatenate the first name, the number of children, and some text, start your formula with a = and then add a & between each element.

The formula here is:

=A2&" has "&B2&" child(ren)"

In this case, to improve the display, it is possible to add functions to handle the singular and plural of "child(ren)" and to display different text if there are no children.

=A2&IF(B2," has "&B2&" child"&IF(B2>1,"ren","")," has no children")