WRAPCOLS function

Category: Lookup and reference
Introduced: Excel 2024

Summary

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

Syntax

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

Example

=WRAPCOLS(A2:F2,3)

Microsoft Support Page

https://support.microsoft.com/en-us/office/wrapcols-function-d038b05a-57b7-4ee0-be94-ded0792511e2

Back to Functions