Help! Complete text in cell not showing

S

Shelley APG

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!!!
 
G

Gary L Brown

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,
 
D

Dave Peterson

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

Shelley APG

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!
 
S

Shelley APG

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!!!!
 
Top