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
🍪

We use cookies to enhance your user experience and analyze website performance. You can revoke consent anytime. Learn more.