Concatenate formula

In Google Sheets, concatenation combines the contents of two or more cells in a worksheet into a third separate cell using the CONCATENATE function or its newer version, CONCAT. Here's what the CONCATENATE function does and how to use it.