Last updated 1 year ago
Was this helpful?
The CONCATENATE function concatenates two or more text strings into one string.
concatenate(string1, string2, ..)
string1, string2.. - Text strings to be joined
concatenate ("Today's price is ",text(6000,"$###,###.00"))
The above formula returns 'Today's price is $6,000'
