Would suggest you post to the programming group.
There might be a simple solution using code.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Elizabeth" wrote in message
...
Yes, I did read your post. I thank you for your interest in helping me
too.
Unfortunately, I cannot use your solution because I have way too many
cells
with this condition. It would take me a very long time to complete this
type
of manual formatting.

Thank you very much,
Elizabeth

"Ragdyer" wrote:

I guess you *didn't* read my post!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Elizabeth" wrote in message
...
Thanks very much for your help. This told me what I needed to know.
It's
not what I wanted to hear, but at least I know that there isn't a way
to
format the cell differently to get it to show the text.

"FSt1" wrote:

hi,
In excel help, type the word specifications.
from the specs...
Length of cell contents (text) 32,767 characters. Only 1,024
display
in
a cell; all 32,767 display in the formula bar.

regards
FSt1

"Elizabeth" wrote:

I am experiencing a problem with populating cells with long text
information
(hundreds of words). It will only show a portion of the text when
viewing
on screen or printing the document. However, when you click on the
cell, it
will display all the text. Does anyone know if there is a software
limit on
visible text in a cell? I have wrapped the text and tried to
resize
the
cells, but nothing works.