FormulaCraft

ARRAYTOTEXT

ARRAYTOTEXT returns a text representation of the values in an array or range. In concise mode (0) it produces a readable comma-separated list; in strict mode (1) it wraps text in quotes and separates items with commas, reproducing the array literal syntax used in formulas.

Topic:SaaS metrics
Excel
=ARRAYTOTEXT(A2:A5,0)
Google Sheets
=ARRAYTOTEXT(A2:A5,0)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1Select or define the range you want to convert (e.g., A2:A5 containing fruit names).
  2. 2Enter =ARRAYTOTEXT(A2:A5,0) for a concise comma-separated result like 'Apple, Banana, Cherry, Date'.
  3. 3Use mode 1 for strict format: =ARRAYTOTEXT(A2:A5,1) returns '{"Apple","Banana","Cherry","Date"}', useful when building formula strings.

Need a version for your data?

Try: “Turn a vertical list of names into a single comma-separated text string”

More on SaaS metrics

See all →
Reference

RANDARRAY

Spills a grid of random numbers with specified rows, columns, min, max, and integer/decimal options. Excel 365 and Google Sheets only.

How-to

How to calculate churn rate

Calculate monthly or annual customer churn rate as lost customers divided by starting customers, expressed as a percentage, in Excel and Google Sheets.

Error fix

Fix #####

Fix ##### in Excel — the column is too narrow to display the number or date. Widen the column or change the format to resolve it.

Reference

MAKEARRAY

Creates an array of specified dimensions by applying a LAMBDA function to generate each cell value.

How-to

How to calculate monthly recurring revenue (MRR)

Learn how to calculate MRR in Excel and Google Sheets using SUMIF to sum active subscription revenue by billing period, normalized to a monthly figure.

Error fix

Fix Array result

Array result was not expanded in Google Sheets means output cells are blocked. Clear adjacent cells or use a blank area.

Related

TEXTJOINLEFT / RIGHT / MIDTRIM

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: