ARRAYTOTEXT Function

The ARRAYTOTEXT function is a text and data function. It is used to return a range of data as a text string.

The ARRAYTOTEXT function syntax is:

=ARRAYTOTEXT(array, [format])

where

array is the range of data to return as text,

[format] is an optional argument. The following values are available:

• 0 the values in the text string will be separated by comma (set by default),
• 1 to enclose each text value in double quotes (except for numbers, true/false values and errors), to use a semicolon as a delimiter and to enclose the whole text string in curly braces.

To apply the ARRAYTOTEXT function,

1. select the cell where you wish to display the result,
2. click the Insert function icon situated at the top toolbar,
   or right-click within a selected cell and select the Insert Function option from the menu,
   or click the icon situated at the formula bar,
3. select the Text and data function group from the list,
4. click the ARRAYTOTEXT function,
5. enter the required arguments separating them by comma,
6. press the Enter button.

The result will be displayed in the selected cell.

Return to previous page