Table of Contents
The WRAPCOLS function in Excel allows users to wrap text within a specified number of columns. This function is useful for organizing and presenting data in a visually appealing manner. By specifying the number of columns, the WRAPCOLS function automatically breaks the text into multiple lines, making it easier to read and comprehend. This feature is especially helpful when working with large amounts of data or creating reports. By utilizing the WRAPCOLS function, users can efficiently manage and present their data in a structured and organized manner.
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 WRAPCOLS function syntax has the following arguments:
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 in a single column.
Errors
Excel returns a #VALUE when vector is not a one-dimensional array.
Excel returns a #NUM when wrap_count is less than 1.
Excel returns a #N/A error for each cell in the return array that has no results.
Wraps the row in range A2:G2 to an array in range A4:C6 of 3 rows. The last two missing elements return #N/A.
Data | ||||||
|---|---|---|---|---|---|---|
A | B | C | D | E | F | G |
Formulas | ||||||
=WRAPCOLS(A2:F2,3) |
Wraps the row in range A2:G2 to an array in range A4:C6 of 3 columns. The last two missing elements return the pad character “x”.
Data | ||||||
|---|---|---|---|---|---|---|
A | B | C | D | E | F | G |
Formulas | ||||||
=WRAPCOLS(A2:G2,3,”x”) |
See Also
Cite this article
stats writer (2024). How can I use the WRAPCOLS function in Excel to wrap text within a specified number of columns?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-wrapcols-function-in-excel-to-wrap-text-within-a-specified-number-of-columns/
stats writer. "How can I use the WRAPCOLS function in Excel to wrap text within a specified number of columns?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-wrapcols-function-in-excel-to-wrap-text-within-a-specified-number-of-columns/.
stats writer. "How can I use the WRAPCOLS function in Excel to wrap text within a specified number of columns?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-wrapcols-function-in-excel-to-wrap-text-within-a-specified-number-of-columns/.
stats writer (2024) 'How can I use the WRAPCOLS function in Excel to wrap text within a specified number of columns?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-wrapcols-function-in-excel-to-wrap-text-within-a-specified-number-of-columns/.
[1] stats writer, "How can I use the WRAPCOLS function in Excel to wrap text within a specified number of columns?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I use the WRAPCOLS function in Excel to wrap text within a specified number of columns?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.