top of page

Discard CONCAT and use TEXTJOIN

Don't miss how the new TEXTJOIN formula available in MS Excel 365 is an improvement over the old CONCAT formula.


TEXTJOIN gives you the option to add delimiters in between a combined range of cells, and choose what to do when there are empty spaces in the range.


The beginning of the formula begins with the delimiter that you select:


. . . this is followed by TRUE or FALSE - TRUE stops empty spaces from being included - FALSE will add them in. Conclude the formula with the range you want to combine.



It is possible to combine multiple ranges with TEXTJOIN


=TEXTJOIN("; ",TRUE,A2:F2,A3:F3)

Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

© 2015 by Sean O'Shea . Proudly created with Wix.com

bottom of page