CONCAT

Combines multiple text values.

Syntax

=CONCAT(text1,text2,…)

Example

First Name	Last Name
Saroj	Pensia

=CONCAT(A2,” “,B2)

Result: Saroj Pensia

TEXTJOIN

Combines multiple text values using a separator.

Syntax

=TEXTJOIN(delimiter,ignore_empty,text1,…)

Example

=TEXTJOIN(“, “,TRUE,A2:C2)

If:

A2 = Sirsa
B2 = Haryana
C2 = India

Result:

Sirsa, Haryana, India

CONCAT vs TEXTJOIN

Function	Main Use
CONCAT	Combine text
TEXTJOIN	Combine multiple values with a separator

Practice

Combine employee information into a single address/text field.