CONCATENATE

  • Updated

Combines several text strings into one text string.

Sample Usage

CONCATENATE("ever","green")
CONCATENATE(B2," ",C2)
CONCATENATE(B2:B10)

Syntax

CONCATENATE(value1, [value2,..])

  • value1 - Text passage or range to be combined. 
  • value2,.. - [OPTIONAL] Additional text passages or ranges to be combined. 

Examples

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.

 

Notes

  • 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).