CONCATENATE function
The CONCATENATE function is one of the text and data functions. Is used to combine the data from two or more cells into a single one.
Syntax
CONCATENATE(text1, [text2], ...)
The CONCATENATE 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 CONCATENATE 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