Why does text in a cell truncate?

G

Guest

Text copied from Word put into a cell gets truncated after a point. In one cell, the whole text shows up in the formula bar when highlighted, but is not showing in Print Preview or in Print, however, the space the text would take up is left empty. In another cell, the cell perimeter itself endes up cutting off the rest of the text from being viewed even after the cell space has been enlarged
 
N

Nick Hodge

Colleen

You don't say how many characters are in the cell but XL will always display
more data in the formula bar than the cell itself. For exact data for your
version type Excel specifications in help.

Regarding the blank spaces, are you copying lots of blank data, lines or
paragraph markers at the end of the data...it shouldn't, but Excel may be
seeing these as characters

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)


Colleen said:
Text copied from Word put into a cell gets truncated after a point. In
one cell, the whole text shows up in the formula bar when highlighted, but
is not showing in Print Preview or in Print, however, the space the text
would take up is left empty. In another cell, the cell perimeter itself
endes up cutting off the rest of the text from being viewed even after the
cell space has been enlarged.
 

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

Top