Combines several text strings into one text string.
- value1 - Text passage or range to be combined.
- value2,.. - [OPTIONAL] Additional text passages or ranges to be combined.
CONCATENATE("ever","green") returns the combined text string, evergreen.
CONCATENATE(B2," ",C2) combines three elements: the string in cell B2, a space character, and the string in cell C2.
CONCATENATE(B2:B10) combines all the elements in the range B2:B10.
- When a range with both width and height greater than 1 is specified, cell values are appended across rows rather than down columns. That is, CONCATENATE(A1:B2) is equivalent to CONCATENATE(A1,B1,A2,B2).