Truncated data

G

Guest

I've been using Excel many years actually since it came out.. But I cannot
beleive I have never seen this simple issue.
I'm typing along in a cell, the format is a simple General type. Then some
of the data I typed is cut off like it's truncated. I extend the cell up or
down still truncated. If I make the font real small my data appears, but I
need it bigger. Is there some kind of limit to the number of bits per cell.
ALso, I have already set the Wrap text.

Suggestions???
 
D

Dave Peterson

If you have lots and lots of characters in the cell, you can add alt-enters (to
force new lines within the cell) every 80-100 characters.

And then you'll be able to see lots more characters in that cell.
 
G

Gord Dibben

Yes, there is a limit on visible characters in a cell.

You can enter 32767 chars but only 1024 will be visible or printed.

See Dave P's post for workaround.


Gord Dibben MS Excel MVP
 

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

String-in-Cell .... too long??? Word Wrap not working...PLEASE HE 3
Printing Entire Contents of Cell 1
Transferring data from MS Access to MS Excel 2
Report data truncated on Access 2007 1
Data in narrow columns truncated when saving as DBF 2
Wrap Text issue 2
VBA ADODB Automation - Truncated Memo Fields 3
the data just won't show! 0

Top