TEXTJOIN is a new function, available in Office 365 and Excel 2019.
The TEXTJOIN function concatenates values from one or more text strings or ranges that contain text. Unlike the CONCATENATE function, TEXTJOIN lets you specify a range of cells and a delimiter to use when joining text values.
To join cells in the range A1:A3 with a comma and space, you can use TEXTJOIN like this:
The second argument, ignore_empty, controls behavior for empty cells and text values. If set TRUE, empty values are skipped so that the delimiter is not repeated in the final result. If set to FALSE, TEXTJOIN will include empty values in the output.
To join cells in the range A1:A3 with no delimiter, including empty values, you can use:
TEXTJOIN is a new function in available in Office 365 and Excel 2019.
Working from the inside out, the MID formula is used to extract the text in B5, one character at a time. The key is the ROW/INDIRECT piece...
At a high level, this formula uses a nested IF function to return an array of holidays between two dates. This array is then processed by the TEXTJOIN function, which converts the array to text using a comma as the...
Working from the inside out, the MID function is used to cast the string into an array of individual letters:
In this part of the formula, MID, ROW, INDIRECT, and...
The core of this formula is the IF function, which "filters" the names in the table by color like this:
The logical test checks each cell in the named range "group" for the color...
At the core, this formula uses an array operation to generate an array of letters from the input text, translates each letter individually to a number, then joins all numbers together again and returns the output as a...
At the core, this formula uses the MID function to extract each character of a text string in reverse order. The starting character is given as a list of numbers in descending order hardcoded as array constant:
The Excel CONCAT function concatenates (joins) values supplied as references or constants. Unlike the CONCATENATE function (which CONCAT replaces), CONCAT allows you to supply a range of cells to join, in addition to individual cell references.