# COLLECT function

This article describes the formula syntax of the COLLECT function

## Description

Collect cells into a range

## Syntax

COLLECT(cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell)

 cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect. cell is a cell to collect.

Assemble up to 30 spreadsheet cells into a range. If all arguments to COLLECT have the same number of columns then the ranges are stacked.