ARRAYTOTEXT Function Explained
The ARRAYTOTEXT Function in Microsoft Excel allows users to convert an array of text strings into a single text string. It takes two arguments: the array of text strings and a delimiter, which is the character used to separate the text strings in the resulting single text string. The delimiter can be any character, including a space, comma, or semicolon.
ARRAYTOTEXT Function Syntax
ARRAYTOTEXT(array, delimiter, no_consecutive_delimiters)
- array: The range of cells to be converted into a text string.
- delimiter: The character used to separate the values in the text string.
- no_consecutive_delimiters: A logical value that specifies whether consecutive delimiters should be removed from the text string.