Excel formula translator
Translator
Functions
Translation table
Error codes
Academy
🔍
Search functions
🌐 EN ▾
English
Deutsch
Français
Español
Português
☰
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 version
Available
Excel 2007
✗
Excel 2013
✗
Excel 2019
✗
Excel 2021
✗
Microsoft 365
✓
Translate a formula with this function
fx
EN
=TOCOL(A2:D4)
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
ADDRESS
AREAS
CHOOSE
CHOOSECOLS
CHOOSEROWS
COLUMN
COLUMNS
DROP
Copied to clipboard
↑
↓
·
Enter
·
Esc
Excel functions ›