Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Text in cells

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    49
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have Excel 97 and typed a 500 character text in a cell. On the edit line, all the characters show, yet on the display, only part of it is displayed. I did wrap text, column width adjustments and smaller fonts. Same thing when it prints in that only part of it is displayed. Please help.

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    Washington State
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Excel has a 256 character limit per cell to the best of my knowledge.

    Rick

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    49
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can i merge two cells together with 1/2 on one cell and the other half of the text on the one below? Any suggestions? Thanks

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    with your 500 chars in A1 you could put =LEFT(A1,250) in one cell and =RIGHT(A1,250) or =MID(A1,251,250) in another below it. is that what you mean?
    another thought is to use a text box

    [ This Message was edited by: anno on 2002-02-20 22:02 ]

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    49
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I was thinking that if Excel 97 allows you to only display 256 characters per cell (i'm sure this is the case), then i would somehow need to break up my 500 character text into two cells. So cell a1 would have 250 characters (or around there) and cell A2 would have the remaining characters. Then on A3, i would somehow merge the cells together and display all 500 characters. I guess the question is, is there a way to get around the 256 character limit via display. When I go to the edit line on cell A1 where i have my 500 character text, I can see all the text on the edit line. Do i need to do some VBA work?

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nope. There's no "workaround", it's just a limitation (I think in Excel 2000 the limit is 1024, so that may be a workaround...)
    Regards,

    Juan Pablo González
    http://www.juanpg.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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