text truncating

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

Guest

Is it possible to have too much text in a cell? The cell is formatted as
general, wrap text with auto fit but will only show three quarters of the
text I have typed into the cell. When I double click on the cell all the text
shows but once I tab out of the cell I loose some of my text.
 
It's only the visibility of the text. Every so often insert a hard return in
the text (ALT-ENTER) to improve the visibility.
 
Supposedly a cell will not show anything beyond 1024 characters whereas it
will show up to 32k in the formula bar. However if you insert alt + enter
quite a bit you should be able to bypass that.


--


Regards,


Peo Sjoblom
 

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

Quote Marks Question 2
wrap text 1
Text Truncates 3
wrapping text in merged cells 2
some text shows in merged cells but not all 2
Text in a cell 2
Excel Typed text appears in wrong cell 0
Why is my text cell showing as # symbols when entered 1

Back
Top