TEXTJOIN() Function to Combine Text in Excel - Excel Quickie 51

This tutorial covers the new TEXTJOIN() function for Excel 2019 and Excel 365 that allows you to easily combine ranges of text, hardcoded values and even transform the text in the process of concatenating it. This tutorial includes 3 sets of examples for the TEXTJOIN() function. This is a new function for Excel 2019 and 365 and it is long overdue - finally we can use a single function to combine a lot of text, values or numbers instead of concatenating everything by hand or in a piecemeal manner. This new function replaces the need for a UDF (User Defined Function), which is what you used to have to use to achieve the same thing. I hope you enjoy this tutorial! #excelquickie