ARRAYTOTEXT() Function Excel - 5 Practical Examples

Add to Favorites
Author: | Edits: don

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

SEQUENCE() Function Excel

TEXTJOIN() Function Excel

Email Course

Question? Ask it in our Excel Forum


Excel Function: SEQUENCE(), TEXTJOIN()
Excel Version: Excel 365
Downloadable Files: Excel File

Our Excel Courses

Professional Input Forms in Excel

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

Send Emails from Excel

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.