AI · 1 min read

ARRAYTOTEXT

ARRAYTOTEXT function in Excel: Array of text values from a range.

Text function · Excel

ARRAYTOTEXT function

Array of text values from a range.

Availability

PlatformStatus
ExcelListed
Google SheetsNot listed
On Google Sheets: use JOIN. Use JOIN or TEXTJOIN with your own delimiter.
Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.