WRAPROWS function

Category: Lookup and reference
Introduced: Excel 2024

Summary

Wraps the provided row or column of values by rows after a specified number of elements

Syntax

WRAPROWS(vector, wrap_count, [pad_with]) The WRAPROWS function syntax has the following arguments:
• vector The vector or reference to wrap.
• wrap_count The maximum number of values for each row.
• pad_with The value with which to pad. The default is #N/A.

Example

=WRAPROWS(A2:G2,3)

Microsoft Support Page

https://support.microsoft.com/en-us/office/wraprows-function-796825f3-975a-4cee-9c84-1bbddf60ade0

Back to Functions