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

Wraps the provided row or column of values by rows after a specified number of elements to form a new array.

🌐 Translations

English WRAPROWS
Deutsch WRAPROWS
Français WRAPROWS
Español WRAPROWS
Italiano WRAPROWS
Português WRAPROWS
Nederlands WRAPROWS
Polski WRAPROWS
Русский WRAPROWS

📦 Availability

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

⌨ Syntax

WRAPROWS(vector,wrap_count,[pad_with])

Arguments

vector (required)
wrap_count (required)
pad_with (optional)

▶ Examples

=WRAPROWS(A2:G2,3)
=WRAPROWS(A2:G2,3,"x")
=WRAPROWS(vector,wrap_count,[pad_with])

Related functions

Copied to clipboard