WRAPCOLS Function Explained

The WRAPCOLS function in Microsoft Excel allows users to wrap text in a cell across multiple lines. This is useful for displaying long text strings in a cell without having to manually adjust the column width. The function takes two arguments: column_width and text. The column_width argument specifies the width of the column in characters, and the text argument is the text string to be wrapped.

WRAPCOLS Function Syntax

WRAPCOLS(column_num, row_num, num_columns, num_rows)

  • column_num: The column number of the upper-left cell of the range to be wrapped.
  • row_num: The row number of the upper-left cell of the range to be wrapped.
  • num_columns: The number of columns in the range to be wrapped.
  • num_rows: The number of rows in the range to be wrapped.