how do i get excel to display the text in the cell??

  • Thread starter Thread starter Jw
  • Start date Start date
J

Jw

hi i am doing some qualitative research and sorta using
excel to sort my text bits and i have put large chunks of
text into the cells, in some cells the words get
displayed in others no matter how big I make the cell I
just get hexe..how do I stop that???
 
Hi
there's a maximum of 1024 characters per cell to be displayed. You may
try adding some manual line breaks with ALT + ENTER.
For moere details have a look at the Excel help (search for
'Specification')
 
there's a maximum of 1024 characters per cell to be displayed. You may
try adding some manual line breaks with ALT + ENTER.
For moere details have a look at the Excel help (search for
'Specification')
Click to expand...
...

Correcting this, Excel's specs mention the 1024 char cell display limit, but
it's a fiction. As long as the text contains appropriately spaced newline chars
and the cell and worksheet are formatted to allow display of more than 1024
chars in the cell, Excel can *display* up to 32762 chars. Now the result is
completely unreadable, but the 1024 char limit only applies if the user does
absolutely nothing to expand the number of characters displayed in the cell.

This is one point on which Excel's written specs differ from what Excel is
actually capable of doing.
 
...
..

Correcting this, Excel's specs mention the 1024 char cell display
limit, but it's a fiction. As long as the text contains appropriately
spaced newline chars and the cell and worksheet are formatted to
allow display of more than 1024 chars in the cell, Excel can
*display* up to 32762 chars. Now the result is completely unreadable,
but the 1024 char limit only applies if the user does absolutely
nothing to expand the number of characters displayed in the cell.

This is one point on which Excel's written specs differ from what
Excel is actually capable of doing.
Click to expand...

Hi Harlan
thanks for the clarification. Should've explained the reason for the
suggested usage of ALT+ENTER a little bit more :-)

Reagrds
Frank
P.S.: I agree that the result is not readable at all :-)
 
Back
Top