Re: Vexing Excel problem

At 12:07 -0800 2004-12-09, E. Bond Francisco wrote:
>I've got an Excel 2003 file open. I'm trying to cram a bunch of text into a
>single cell. When I highlight the cell, I see all the text in an "expansion"
>window, indicating that the text is there. When I deselect the cell, I only
>see the upper 15 or so lines. The rest does not appear, either on screen, or
>in print preview. I've got the cell formatted to WRAP TEXT, text direction
>is CONTEXT, Vertical and Horizontal are set to GENERAL. Any suggestions on
>how I can get the last 15 lines to show up in this cell?

   In the first two random articles retrieved from a search, there are
allegations ;-) that Excel has a limit of 1024 displayed characters
in a worksheet cell:

   http://www.eng-tips.com/viewthread.cfm?qid=8361&page=33 (Excel 97)

   http://www.ntcompatible.com/thread25660-1.html (Excel 2002)

   You could likely confirm or debunk this limitation by digging a bit
further in Microsoft's own docs.

   There are two responses in the first article above suggesting some
possible workarounds.

Aron Roberts
Workstation Software Support Group

------------------------------------------------------------------------
The following was automatically added to this message by the list server:

For information about Micronet, including subscribing to
or unsubscribing from its mailing list and finding out
about upcoming meetings, please visit the Micronet Web site:
<http://micronet.berkeley.edu/>.
Received on Thu Dec 9 12:26:25 2004