Home › Functions › Lookup & Reference › TOCOL
fx
TOCOL
Lookup & Reference  ·  Since: Microsoft 365  ·  9 languages

Returns the array in a single column.

🌐 Translations

English TOCOL
Deutsch ZUSPALTE
Français TOCOL
Español TOCOL
Italiano A.COL
Português TOCOL
Nederlands NAAR.KOLOM
Polski TOCOL
Русский ПОСТОЛБЦ

📦 Availability

Excel versionAvailable
Excel 2007 ✗
Excel 2013 ✗
Excel 2019 ✗
Excel 2021 ✗
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

TOCOL(array,[ignore],[scan_by_column])

Arguments

array (required)
ignore (optional)
scan_by_column (optional)

▶ Examples

=TOCOL(A2:D4)
=TOCOL(A2:D4,1)
=TOCOL(A2:D4,1,TRUE)

Related functions

Copied to clipboard