Skip to content
ExcelExcel 2024+

WRAPCOLS function in Excel

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

=WRAPCOLS(vector, wrap_count, [pad_with])

WRAPCOLS syntax and parameters

Three arguments, two required.

  • vectorarrayRequired
  • wrap_countnumberRequired
  • pad_withanyOptional

WRAPCOLS examples

Formulas you'll actually reuse.

  1. A 24-month list split into two columns of 12 — year 1 beside year 2:

    =WRAPCOLS(A2:A25, 12)

  2. Days into week-columns, padding the short last one with blanks instead of #N/A:

    =WRAPCOLS(A2:A31, 7, "")

WRAPCOLS in Google Sheets

Same name — your formula ports as-is.

Try WRAPCOLS in the playground

Edit the example — nothing to install.

Preloaded with the WRAPCOLS formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.