Use the TEXTJOIN function to join text strings with a specified delimiter

Use the TEXTJOIN function to join text strings with a specified delimiter

Syntax: TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

Step 1: Define the delimiter, whether to ignore empty cells, and the text strings or cell references to join.

Step 2: Enter the formula in a cell and press Enter.value.

For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com