Text in cells

[Ket]

Hello,

I am using Office and Windows 2003. I have a spreadsheet that contains
data in the form of text.
In some of the cells there is a large amount of text. In some cells
this text does not appear in full. When you click on the cell the text
is displayed in full in the formula bar however once you click back
into the workbook the text is truncated and only shows the first 3-4
lines.
This happens on some but not all of the cells in a particular column.

Any ideas of why this happens and how it can be overcome?

TIA

Ket
London

 

[Guest]

Check your text alignment to see if all the cells are
formatted the same.

 

[Guest]

These text cells should be formatted with "word wrap". Then size the width
and height of the columns/rows to allow sufficient space to display all of
the text.

You could also break larger chunks of text into multiple cells.

Reminder: Excel is not a good place to try to manipulate large amounts of
text. Word is great at that.

HTH

Bruce

 

[Gord Dibben]

Ket

Excel Help on "Limits" states that a cell can contain 32,767 characters but
will show or print only 1024 of these by default.

To get more to show enter a few ALT + ENTERs at appropriate spots througout,
say, every 832 characters.

The ALT + ENTER inserts a carriage-return.

There is still a limit to how much will show. You will find it eventually.

As an alternative try using Text Boxes to enter your long text fields.

Gord Dibben Excel MVP