CONCATENATE
Description
Concatenates the string arguments, in order, into 1 string.
Syntax
CONCATENATE(
text
, ...)
- text: The strings to concatenate.
Example
Formula | Result |
|---|---|
=CONCAT(A1," ",B1)
Where cell A1 contains
John
and cell B1 contains
Davis
.
| John Davis |
Notes
- This function does the same action as CONCAT().