increase cell character limit

[Weissme]

Hi all,

Simple question that is driving me crazy. I'm making a table
containing text and numbers. One of the cells in this table has 1459
characters. For some reason, the last couple sentences won't fill the
bottom of the cell; instead, they're cut off. I can only see them if I
increase the column width, but I don't want to do that since it'll
complicate other things (readability, etc). So, how do I get all the
text/characters to display in this cell?

Thanks

 

[Bob Umlas]

You've reached the limit of DISPLAYing the data - the cell can HOLD the data
but not display it well. I recommend you put all the data inside a Textbox
which can display it.
Bob Umlas
Excel MVP

 

[Dave Peterson]

If you add alt-enters every 80-100 characters to force new lines within the
cell, you'll see more characters.

 

[Bill Sharpe]

Hi all,

Simple question that is driving me crazy. I'm making a table
containing text and numbers. One of the cells in this table has 1459
characters. For some reason, the last couple sentences won't fill the
bottom of the cell; instead, they're cut off. I can only see them if I
increase the column width, but I don't want to do that since it'll
complicate other things (readability, etc). So, how do I get all the
text/characters to display in this cell?

Thanks

As Aaron would probably suggest, use Access and create a memo field to
hold all this text...<vbg>

Bill