Included in the group of six functions released by Excel 2016 is a very valuable function; TEXTJOIN. This tool makes it easier to combine strings of data within minutes rather than having to select each cell individually or having to be extremely skilled at forming custom functions. TEXTJOIN has a number of noteworthy features, including the ability to select an entire range of cell references that must be combined together.
Before TEXTJOIN was released, the process of combining data was done by using two different methods, including the “& function” and the “concatenate function”, both of which are not used as extensively anymore. In the functions prior to the release of TEXTJOIN, you would need to make cell references to each cell or string. TEXTJOIN has improved this aspect of Excel by allowing the ability to utilize cell ranges rather than having to make individual cell references. The syntax for this function is:
In the function, the delimiter has to be interested in the form of text string which can include a variety of characters or even refer to a valid text string by using double quotes. You could leave the argument of delimiter blank, which would simply concatenate the text in a single contiguous string.
If the “ignore_empty” argument of the function has been set to “