CONCATENATE

Description

The CONCATENATE function joins (concatenates) two or more strings of text.

Syntax

CONCATENATE(string1, string2, [string3, . . .])

• string1: The string that becomes the first segment of the result. To include a string in the argument, place quotation marks around it.
• string2: The string that becomes the second segment of the result.
• string3: Additional strings to be appended to the first two.

Note: You can also use the & operator to concatenate strings.

Examples