Share via

WRAPCOLS function returns "#NAME?" error

Anonymous
2023-08-09T14:51:54+00:00

I am trying to use the WRAPCOLS function on Excel for Microsoft 365. It does exist on my version of Excel ("#NAME?" error) even though it appears that it should. How can I access this formula?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-08-09T15:22:14+00:00

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-08-09T15:13:48+00:00

    Yes, that is the syntax that I used. Unfortunately, it still returns the Name error for me.

    Microsoft Office 365 Apps for Enterprise

    Microsoft® Excel® for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20936) 64-bit

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-08-09T14:58:58+00:00

    =WRAPCOLS(B2:B7,2,)

    I have sent the test file to you via private message. Could you check if that works at your side?

    If it still Name# error, share us your office version.

    About Office: What version of Office am I using? - Microsoft Support

    • 1 - Product name, such as Microsoft 365 ProPlus or Office Home and Student.
    • 2 - Version number, which includes version, build number, and the type of installation such as Click-to-run or Windows Store.

    Was this answer helpful?

    0 comments