What does it do?

Concatenates a list with a specified delimiter

Formula breakdown:

=TEXTJOIN(delimiter, ignore_empty, text1, …)

What it means:

=TEXTJOIN(the delimiter, ignore empty cells in combining text, first text/range to combine, …)

Do you want to combine text or a range of cells together easily? The TEXTJOIN Formula in Excel will do this for you in a flash! The TEXTJOIN Formula was introduced in Excel 2016.

It can even let you specify a delimiter to use to combine the text together and ignore empty cells for you!

I explain how you can do this below:


STEP 1: We need to enter the TEXTJOIN function in a blank cell:


TEXTJOIN Formula in Excel


STEP 2: The TEXTJOIN arguments:


What is the delimiter to use in combining the text?

We want to have the text combined together and separated by a comma:


TEXTJOIN Formula in Excel


Do you want to ignore the empty cells?

Let us set this to TRUE to ignore the empty cells when combining them together:


TEXTJOIN Formula in Excel

text1, …

Which cells do you want to combine together?

Select the range of cells that you want to combine together


TEXTJOIN Formula in Excel

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

TEXTJOIN Formula in Excel

You now have your combined text!

TEXTJOIN Formula in Excel


How to Use the TEXTJOIN Formula in Excel




If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Related Excel Tutorials