Skip to content

The WRAPCOLS FUNCTION

The WRAPCOLS FUNCTION

[vc_row][vc_column][vc_column_text]

WRAPCOLS Function

Excel for Microsoft 365 Excel for Microsoft 365 Mac Excel for Web

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])

 

The arguments in the syntax of WRAPCOLS are:

  • 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.

 

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.

 

Examples

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.

 

Example1

Data
A B C D E F G
Formulas

=WRAPCOLS(A2:F2,3)

 

Example2

Data
A B C D E F G
Formulas

=WRAPCOLS(A2:G2,3,”x”)

[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][mk_image src=”https://peakup.org/wp-content/uploads/2023/12/office_imza_son.gif” image_size=”full” link=”https://peakup.org/global/office-training/” target=”_blank”][/vc_column][/vc_row]