ARRAYTOTEXT function in Excel allows you to convert an array of values into a single text string. It can be useful for consolidating data or preparing it for presentation or analysis.


=ARRAYTOTEXT(array, delimiter, [skip_blanks])


arrayThe range or array of values you want to convert to text.
[format](optional) Output format. 0 = concise (default), and 1 = strict.

How to use

Let’s look at some examples of how to use the ARRAYTOTEXT function:

This formula will take the values in cells A1 to A5 and separate them with a comma and a space, creating a text string like “Value1, Value2, Value3, Value4, Value5.”

Additional information

It’s important to note that the ARRAYTOTEXT function is particularly useful when you need to create a comma-separated list of values or when you want to consolidate data from multiple cells into a single text string.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.