# WRAPCOLS

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content

This function wraps the provided row or column of values by columns after a specified number of elements to form a new array.

## Syntax

=WRAPCOLS(vector, wrap\_count, [pad\_with])

## Arguments

The function has the following arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *vector* | The vector or reference to wrap. |
| wrap\_count | The maximum number of values for each column. |
| pad\_with | [Optional] The value with which to pad. The default is #N/A. |

## Remarks

The elements of the vector are placed into a 2-dimensional array by column. Each column has wrap\_count elements. The column is padded with pad\_with if there are insufficient elements to fill it. If wrap\_count is greater or equal to the number of elements in vector, then the vector is simply returned as the result of the function.

## Data Types

The function returns an array, the type of each value in the array depends on the parameter.

## Examples

![](https://cdn.mescius.io/document-site-files/images/0ed25d3e-6b2a-4cf0-8f1b-7ed5ab18cf12/images/wrapcols-new.png)

## Version Available

This function is available in product version 16.0 or later. 

> !type=note
> **Note**: The WRAPCOLS function is only available in Beta Insiders builds of Excel for Office 365 currently. Hence, without the Beta Insiders build you cannot import/export the XLSX using this function from/to Excel.