Voci con l'etichetta :
Chiudi
Changelog
Chiudi
Voci con l'etichetta :
Chiudi
Provalo nel cloud

ARRAYTOTEXT Function

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

Syntax

ARRAYTOTEXT(array, [format])

The ARRAYTOTEXT function has the following arguments:

Argument Description
array The range of data to return as text.
format An optional argument. The possible values are listed in the table below.

The format argument can be one of the following:

Format Explanation
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.

Notes

How to apply the ARRAYTOTEXT function.

Examples

The figure below displays the result returned by the ARRAYTOTEXT function.

ARRAYTOTEXT Function

Alla pagina precedente
Try now for free Try and make your decision No need to install anything
to see all the features in action