Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Oct 2005
    Posts
    599
    Thanks
    1
    Thanked 1 Time in 1 Post

    Limits on number of characters in a cell? (Excel 2003)

    Is there a limitation on the number of text characters that you can put in a cell? I have seen mention of 255 characters; someone said it was 1,00 characters; how can that be overcome ?--by merging enough cells to accommodate all the characters ????

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Limits on number of characters in a cell? (Excel 2003)

    Type specifications in the help box.

    A cell can contain at most 32,767 characters. Only the first 1,024 characters will be displayed in the cell itself; all 32,767 characters will be displayed in the formula bar. Merging cells will not increase their capacity.

    If you really need more, you should ask yourself whether Excel is the most suitable application for what you want.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limits on number of characters in a cell? (Excel 2003)

    The exact number of characters Excel will show depends on the cell's font settings. e.g. with Arial 10, I see about 3200 characters, with Arial 8, I see about 3600.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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