Though wrap text is enabled, words at right end of cell are trunca

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Even though "wrap text" was enabled, the text in a cell towards the right
extreme were not displayed. Whereas the text was visible in the Formula Bar.
The total size of the Text in the cell was 241 words (1576 characters).

The autofit option for the cell did not help. Please suggest a possible
solution for this.
 
Amidesh

There is a limit on the amount of text in an Excel cell. From Help in 2003

32,767 characters, only 1,024 display in a cell; all 32,767 display in the
formula bar

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
 
I have this problem, even w/ cells that have as few as 92 words w/ only 633
total characters, including blanks. I have tried everything re: cell
alignments, row adjustment, deletion of all formatting and starting over w/
cell wrap, etc. The only thing I can do is manually expand the height of the
row, and if I use Row Adjust again (like, when I readjust the entire sheet) I
have to go back to these rows and manually change their height again. I think
there is an application error here.
 
Back
Top