Wraps the provided row or column of cells by columns after a specified number of elements to form a new array.Learn more
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.