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.
Host ONLYOFFICE Docs on your own server or use it in the cloud
Article with the tag:
Browse all tags