CONCATENATE

Concatenates multiple strings into one.

Parameter List

Syntax
CONCATENATE(string1
[string2]
)
string1

The first string. For example: "Spreadsheets are ".

[optional] string2

Another string. For example: "awesome".

Examples

CONCATENATE(A1, A2, A3) returns "5John2"Example 1