TEXTJOIN Function Explained
The TEXTJOIN function in Microsoft Excel allows users to join multiple strings of text into one string. It takes two arguments: delimiter and ignore_empty. The delimiter argument is used to specify the character or string that will be used to separate the strings of text. The ignore_empty argument is used to specify whether empty strings should be ignored or not.
TEXTJOIN Function Syntax
TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)
- delimiter: The character or characters that will be used to separate the text strings.
- ignore_empty: A logical value that determines whether empty strings should be ignored or not. TRUE will ignore empty strings, FALSE will include them.
- text1: The first text string to be joined.
- text2: (Optional) The second text string to be joined.
- …: (Optional) Additional text strings to be joined.