CONCATENATE

Learn how to join multiple text strings into one single combined text value.

The CONCATENATE function concatenates two or more text strings into one string.

Syntax

concatenate(string1, string2, ..)

Arguments

string1, string2.. - Text strings to be joined

Example

CONCATENATE(
    "Today's profit is ", "6000"
)
// Returns 'Today's profit is 6000'

Concatenation

Excel equivalent

CONCATENATE