Skip to Content

WRAPCOLS

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

Syntax

WRAPCOLS(vector, wrap_count, [pad_with])

Parameters

  • vector: Required. The vector or reference to wrap
  • wrap_count: Required. The maximum number of values in each column
  • pad_with: Optional. The value to pad with. Default is #N/A

Example

=WRAPCOLS(A1:A12, 4)
Returns: ArraySince: Microsoft 365