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