CONCATENATE

Joins 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 price is ",text(6000,"$###,###.00"))

The above formula returns 'Today's price is $6,000'

Concatenation

Excel equivalent

CONCATENATE