Joins the specified text values into a single text value.
Syntax
 Copy Code
|
|---|
CONCATENATE( [Text text1], [Text text2], ... ) → Text |
Parameters
- text1
text2
… - Zero or more text items to be joined into a single text value.
Remarks
If there are no arguments provided, the function returns an empty text value.
The "&" operator can be used instead of CONCATENATE to join text items.
Example
| Formula
Copy Code
|
|---|
=CONCATENATE("The date and time is ",NOW()) |
See Also
Function Reference