Results 1 to 3 of 3

Text Length restrictions on a cell in Excel

This is a discussion on Text Length restrictions on a cell in Excel within the Excel Questions forums, part of the Question Forums category; I recently imported text form a Word Table into an Excel spreadsheet, and the text will not fully display in ...

  1. #1
    New Member
    Join Date
    Jun 2003
    Posts
    4

    Default Text Length restrictions on a cell in Excel



    I recently imported text form a Word Table into an Excel spreadsheet, and the text will not fully display in the cell. Does anyone know how I can resolve this? I tried changing the settings on the cell by going under Data; Validation, and changing the settings there... but it didn't work. I also went under Format and changed the Format to text.... and still.... this did not work! I changed the font size, widened the cell, etc... seems like I tried everything, and nothing seems to work! Does anyone have an idea??

    I would greatly appreciate it!


  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    68,859

    Default Re: Text Length restrictions on a cell in Excel

    Well, according to Excel specifications the maximum length of cell contents (text) is 32,767 characters, but only 1,024 display in a cell. Also the maximum column width is 255 characters so you will need to wrap the text (Format Cells|Alignmnet tab).

  3. #3
    New Member
    Join Date
    Jun 2003
    Posts
    4

    Default Re: Text Length restrictions on a cell in Excel

    Thanks Andrew.....

    I guess I have tired everything... looks like it's not possible to display ALL the text!!

    Much appreciated!

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
  •  


DMCA.com