Help! Complete text in cell not showing

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

Guest

Hi Guys!

I have exported information into excel and for some reason when looking at
the worksheet some of the text is not showing in the larger text cells as
complete.

When I click on the cell the text appears in whole but looking at the
worksheet it cuts off.

I have used format, wrap text. I have adjusted all columns, I have tried
AutoFit and still nothing.

Any suggestions would be greatly appreciated!!!
 
Unfortunately, until the new Excel comes out, the 'visible' limit in a cell
is 1024 characters. The new Excel will, reportedly, show a million
characters.
HTH,
 
If you add alt-enters to force a new line within the cell every 80-100
characters, you can see way more than the documented 1000 characters.
 
Thank You So much for your responses!

I can not tell you how much time I waisted on that one!

Hope to see the new excel version soon!
 
Ok, one more quick question.... will this effect saving as a CSV file and
importing it into a different program? Will all text go through regardless of
what is visible? Thank You!!!!
 

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

Wrap text in cell 1
Why does my text in a cell with wrap text and auto height get cut 4
Why wont 'autofit' and 'wrap text' remain in tact? 3
Wrapping Text in Merged Cells 4
Auto fit and text wrapping problem 1
Referencing a cell in other worksheet that is using autofit row he 3
Excel autofit row height not working 0
Line Break Vlookup 2

Back
Top