WRAPCOLS

Wraps the provided row or column of cells by columns after a specified number of elements to form a new array.Learn more

Video field
Array

The function takes three arguments:

range: The range of cells that you want to wrap. This can be a range of cells specified using A1 notation or a reference to a cell range.

wrap_count: The number of columns that you want to wrap the range into.

pad_with: An optional argument that specifies the character that you want to use to pad the contents of the wrapped cells. If this argument is not provided, the function will use a space character to pad the contents.

The WRAPCOLS function works by taking the contents of the range and breaking it up into smaller pieces that fit within the specified number of columns. It then adds padding to the end of each smaller piece to ensure that they all have the same length.

Here's an example of how to use the WRAPCOLS function: =WRAPCOLS(A1:A10, 3, "-")

This function wraps the contents of cells A1 to A10 into three columns and pads each wrapped cell with the "-" character. The result will be a new range of cells with the wrapped contents.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!