Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have an user who is creating a table in Excel.
    She has to type a large amount of text in one cell.
    I know that a cell can hold 32000 characters but only display 1024 in the cell.
    Is there a way around this? She has a little over 1060.
    I know....a table in word would be better however someone else set this up and they like using excel.

    Please advise...

    Thanks,
    Deborah

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi Deborah,

    There is a bug in Excel versions prior to Excel 2007 that allows more than 1024 characters to be displayed if the cell is formatted as text, with an upper limit of around 1200 characters (the actual character limit depends on cell/font formatting). The catch is that cells formatted as text won't display strings longer than 255 characters and shorter than 1024 characters. And, in Excel 2007, the bug has been fixed - cells formatted as text won't display strings longer than 255 characters.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Add a linefeed within the text - either using Alt+Enter or CHAR(10) in a formula.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi Rory,

    I don't think that overcomes the display limit (it doesn't for me).
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You could break it up into paragraphs of less than 1000 chars and put them into separate cells...

    Steve


  6. #6
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Alternatively, one could put all the text into a borderless text box positioned over the corresponding cell. That allows as much text as anyone might ever want to display, neatly located in the correct location with no apparent cell breaks ...
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  7. #7
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for all the suggestions.

    I have basically told her the same. My best advice is to split the content up into multiple cells.

    It is funny that you have the ability to type in 32000 characters and only see 1024 on the spreadsheet.

Posting Permissions

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