ARRAYTOTEXT() Function Excel - 5 Practical Examples
5 Practical uses of the ARRAYTOTEXT() Function in Excel.
It works well for creating nice visual lists and also array-formatted text output, complete with the semicolons and the curly braces around it.
This function kind of seems to sit between the CONCAT() and the TEXTJOIN() functions and it is only available for Excel 365.
The examples in this tutorial include:
- Making simple numbered lists in Excel.
- Making text lists in Excel.
- Making dynamic lists by nesting functions.
- Outputting unique lists of values from a Table.
- Creating useful lists of values, such as for sending emails.
Additional Resources
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)