In Short: CONCAT vs. TEXTJOIN . Both combine text from multiple cells into one. According to Cambridge Dictionary, the verb to concatenate means "to put things together as a connected series," and ...