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:

DOWNLOAD EXCEL WORKBOOK

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

=TEXTJOIN(

TEXTJOIN Formula in Excel

 

STEP 2: The TEXTJOIN arguments:

delimiter

What is the delimiter to use in combining the text?

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

=TEXTJOIN(“,”,

TEXTJOIN Formula in Excel

ignore_empty

Do you want to ignore the empty cells?

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

=TEXTJOIN(“,”, TRUE,

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(“,”, TRUE, C9:E9)

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

HELPFUL RESOURCE:

 

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Related Excel Tutorials