CONCATENATE
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'
Excel equivalent
Last updated
Was this helpful?