increase cell character limit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Weissme - 02 Aug 2006 15:29 GMT

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

Signature

Weissme

Reply to this Message

Bob Umlas - 02 Aug 2006 15:35 GMT

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

> Hi all,
>
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

Dave Peterson - 02 Aug 2006 15:58 GMT

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

> Hi all,
>
[quoted text clipped - 13 lines]
> Weissme's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34044
> View this thread: http://www.excelforum.com/showthread.php?threadid=567456

Signature

Dave Peterson

Reply to this Message

Bill Sharpe - 03 Aug 2006 22:07 GMT

> Hi all,
>
[quoted text clipped - 7 lines]
>
> Thanks

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

Bill

Reply to this Message