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

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

Nick Hodge

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
 
P

Paladin

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cells-Text-WordWrapProblems 1
why does wrap text not work in the cell if multiple lines 1
Text is cut off even though wrap text is enabled. 2
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2
Word Wrap in Cell Stops??? 3
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2
Expanding Capabilities of Wrap Text in a cell 1
large text amount in cell will not display in the cell 3

Top