MICROSOFT EXCEL TEXTJOIN FUNCTION

Courtesy of
DJH Training & Application Solutions Inc.

Use the TEXTJOIN function to quickly and easily string cell content together

Available in 365 and 2019 versions of Excel, the TEXTJOIN function allows you to easily combine text from multiple ranges and/or strings, plus includes a delimiter you specify only once to be included between each text value.  If the delimiter is empty, the function will concatenate the ranges.

EXAMPLE 1:  

You would like to transform this:

To this, which you can use in Excel or copy/paste into any program:

 

 

EXAMPLE 2  

You would like to transform this:

To this:

---

 

Here are the two TEXTJOIN formulas you would use.

 

The 1st argument is Delimiter, which is a character or string within double quotes; the 2nd argument is Ignore_Empty, the default to ignore empty cells; the 3rd argument, Text1, is the range or strings to join. We have used a table column, but you can also refer to range(s) of cells.

You can enter up to 252 texts.

 

 

 

 

 

Would you like to learn more about TEXTJOIN or other Excel functions? Contact us!

 

 

 

 

 

 

 

---

More Newsletter Articles