## 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( `

## 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(“,”, `

** Ignore_empty **

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

`=TEXTJOIN(“,”, TRUE,`

** Text1, … **

Select the range of cells that you have to combine together

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

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

Here is your result;