CONCAT

Combines two text strings.

Sample Usage

CONCAT("ever","green")
CONCAT(B2,C2)

Syntax

CONCAT(text1, text2)

  • text1 - The first text passage to be combined. 
  • text2 - The second text passage to be combined.

Examples

CONCAT("ever","green") returns the combined text string, evergreen. 
CONCAT(B2,C2) combines the text strings in B2 and C2.