Lookup & Reference
Excel 365
◉ 4 views
Dynamic Array
=WRAPCOLS()
WRAPCOLS function
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for Mac
=WRAPCOLS(vector, wrap_count, [pad_with])
Hover argument names in the table for details.
Output typeArray
Popularity25 / 100
VolatileNo
Dynamic ArrayYes
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =WRAPCOLS() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
vector |
Array | Optional | The vector or reference to wrap. |
wrap_count |
Number | Optional | The maximum number of values for each column. |
pad_with |
Any type | Optional | The value with which to pad. The default is #N/A. |
▣ Examples
پیچیدن بردار A2:G2 به ستونهایی با حداکثر ۳ مقدار و پر کردن با x
=WRAPCOLS(A2:G2,3,"x")
✦ Tips
- 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.
⚠ Common Errors
#N/A
The default is #N/A. Excel returns a #N/A error for each cell in the return array that has no results.
Fix: در صورت نیاز مقدار pad_with را مشخص کنید یا نتیجه را با IFERROR مدیریت کنید.
#VALUE!
Excel returns a #VALUE when vector is not a one-dimensional array.
Fix: Select a single-row or single-column range
#NUM!
Excel returns a #NUM when wrap_count is less than 1.
Fix: برای wrap_count عددی بزرگتر یا مساوی ۱ وارد کنید.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!