Text Length restrictions on a cell in Excel

[cmgiggles]

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!

 

[Andrew Poulsom]

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).

 

[cmgiggles]

Thanks Andrew.....

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

Much appreciated!