These functions are used to combine text from multiple cells.

CONCAT

Syntax

=CONCAT(text1,text2,…)

Example

First Name

Last Name

Full Name

Amit

Kumar

  

Formula:

=CONCAT(A2,” “,B2)

Result:

Amit Kumar

TEXTJOIN

Purpose

Combines multiple text values using a delimiter.

Syntax

=TEXTJOIN(delimiter,ignore_empty,text1,text2,…)

Example

First Name

Middle Name

Last Name

Amit

  

Kumar

Formula:

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

Result:

Amit Kumar

The TRUE argument ignores empty cells.

Using &

Text can also be combined with the & operator.

=A2&” “&B2

Result:

Amit Kumar

Practice

Create an Employee Directory with:

  • First Name
  • Middle Name
  • Last Name
  • Full Name
  • Department

Use CONCAT, TEXTJOIN, and &.

PreviousNext