
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.

