CONCAT Function

The CONCAT function is one of the text and data functions. Is used to combine the data from two or more cells into a single one. This function replaces the CONCATENATE function.

Syntax

CONCAT(text1, [text2], ...)

The CONCAT function has the following arguments:

Argument	Description
text1/2/n	Up to 255 data values that you want to combine.

Notes

How to apply the CONCAT function.

Examples

There are three arguments: text1 = A1 (John), text2 = " " (space), text3 = B1 (Adams). So the function will combine the first name, the space and the last name into one cell and return the result John Adams.