ARRAYTOTEXT Function in Excel: Syntax, Examples and Free Practice
ARRAYTOTEXT is an Excel Text function. Returns an array of text values from any range, joined together.
ARRAYTOTEXT syntax
Arguments
array: The range or array to evaluateformat: How the result should be formatted (optional)
When to use ARRAYTOTEXT
ARRAYTOTEXT is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice ARRAYTOTEXT online, free
Open the live Excel-style spreadsheet and try ARRAYTOTEXT yourself. No Excel install or sign-up needed to start.
Practice ARRAYTOTEXT now →More Text functions
Frequently asked questions
What does the ARRAYTOTEXT function do in Excel?
Returns an array of text values from any range, joined together.
What is the syntax of ARRAYTOTEXT in Excel?
The syntax is =ARRAYTOTEXT(array, [format]). array: The range or array to evaluate; format: How the result should be formatted (optional).
Where can I practice ARRAYTOTEXT online for free?
Open the free live spreadsheet on Cellgrids and try ARRAYTOTEXT yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts