increase cell character limit

  • Thread starter Thread starter Weissme
  • Start date Start date
W

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
 
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
 
If you add alt-enters every 80-100 characters to force new lines within the
cell, you'll see more characters.
 
Weissme said:
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
Click to expand...
As Aaron would probably suggest, use Access and create a memo field to
hold all this text...<vbg>

Bill
 
Back
Top