The TEXTJOIN Function in excel |
The TEXTJOIN function in Excel is a powerful tool that allows you to combine text from multiple ranges or strings, while specifying a delimiter between each value.
delimiter (required) : A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. If a number is supplied, it will be treated as text.
ignore_empty (required) : If TRUE, ignores empty cells.