TEXTJOIN Formula in Excel

The TEXTJOIN formula joint (concatenates) values with a specific delimiter. It allows you to supply a range of cells, and also has a setting which can help you to ignore empty values. 

Formula breakdown is written here:

=TEXTJOIN(delimiter, ignore_empty, text1, …)

Delimiter= it is the separator between each text. 

Ignore_empty = ignore empty cells in combining text.

 Text1 = first text/range to combine.

If you want to combine text or a range of cells together easily then TEXTJOIN formula will help you. TEXTJOIN formula was introduced in excel 2019.

It will help you in specifying a delimiter to use to combine the text together and ignore the empty cells for you. 

Previously In Excel Formulas: How to use SWITCH Formula in Excel? (2 SIMPLE STEPS)

Following are the steps for applying TEXTJOIN in excel:

STEP1. You have to enter the TEXTJOIN function in a blank cell:

=TEXTJOIN( 

TEXTJOIN Formula

STEP2. Now continue with the TEXTJOIN arguments:

DELIMITER

Now you have to decide which delimiter you want to use to combine the text.

You have to combine the text together and separate them by a comma:

=TEXTJOIN(“,”,

TEXTJOIN Formula1

Ignore_empty

You set the TRUE to ignore empty cells while combining them together:

=TEXTJOIN(“,”, TRUE,

TEXTJOIN Formula2

Text1, …

Select the range of cells that you have to combine together 

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

TEXTJOIN Formula3

Now with the help of lower right corner apply this formula to the other cells by dragging it downwards.

TEXTJOIN Formula4

Here is your result;

TEXTJOIN Formula Final