Consulting

Results 1 to 6 of 6

Thread: Maximum number of characters in cell

  1. #1

    Maximum number of characters in cell

    Is there a limitation of the number of characters an excel-cell can hold?
    I have a large cell formatted with "text" and "word wrap" and want to use it for input of longer texts.
    When I write more than 255 characters the cell shows "#########".
    Is there a way to change that?

  2. #2
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,897
    Location
    Hello and welcome to VBAX!!

    Check out this blog about Office 12 to see the current and upcoming restrictions: http://blogs.msdn.com/excel/

    To combat any autofit nuances, check out this KB entry.

  3. #3
    Administrator
    2nd VP-Knowledge Base
    VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    Quote Originally Posted by CptGreenwood
    Is there a limitation of the number of characters an excel-cell can hold?
    I have a large cell formatted with "text" and "word wrap" and want to use it for input of longer texts.
    When I write more than 255 characters the cell shows "#########".
    Is there a way to change that?
    What version of excel are you using? I know that (at least) Excel 97 through Excel 2000 can hold 32,000 characters in a cell - funny, cause I just read that today at work - but some formulas will not handle cells that contain more than 255 characters of text.

    And definitely take a look at that link that Zack posted Good Stuff




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

  4. #4
    I'm using Office XP. I've found an article on MSDN about the limitations of Excel 2000. There it's been said that the maximum number of chars in a cell is about 32000 and 1024 of them can be displayed in the cell.

    But with "my" excel I get that "#######" after 255 chars.

  5. #5
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,897
    Location
    That is because it cannot all be displayed in lieu of the column width.

  6. #6
    Administrator
    Chat VP VBAX Guru johnske's Avatar
    Joined
    Jul 2004
    Location
    Townsville, Australia
    Posts
    2,872
    Location
    Also, check out this kb entry by byundt http://www.vbaexpress.com/kb/getarticle.php?kb_id=421 it allows more than 1024 characters per cell to be displayed and printed...
    You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you

    The major part of getting the right answer lies in asking the right question...


    Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •