Computer Training & Application Solutions made Simple
Contact us for a free consultation
  • Click to send us an email. We'd love to hear from you!   Ottawa       613-656-4229
  • Click to send us an email. We'd love to hear from you!   Montreal    514-342-9494

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

© 2022 DJH Training & Application Solutions Inc.

WOULD YOU LIKE TO USE THIS ARTICLE IN YOUR NEWSLETTER, EZINE OR WEB SITE? You can, as long as you include this complete blurb with it: An entrepreneur at heart, Deborah J. Sparks established DJH Training & Application Solutions Inc. over 25 years ago, realizing her dream of creating a company known for providing high quality computer software training, application development and support and exercising her passion for teaching. To learn more and to register for DJH's free newsletter, Innovations, please visit www.djhsolutions.ca.