Text
ARRAYTOTEXT function
Values of an array as one text. ARRAYTOTEXT works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.
Syntax
=ARRAYTOTEXT(array, [format]) | Argument | Use |
|---|---|
array | required |
format | optional |
On live data
In Sheets, ARRAYTOTEXT sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.
More text functions
CONCATJoin text stringsLEFTFirst characters of textLENString lengthLOWERLowercasePROPERCapitalize each wordSUBSTITUTEReplace textTEXTFormat a number or date as textTEXTJOINJoin texts with a delimiterTRIMRemove extra spacesASCFull-width characters to half-widthBAHTTEXTNumber as Thai baht textCHARCharacter for a code from 1 to 255
Spreadsheet formulas on live business data
Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.