Text Wrapping Issue

[Guest]

This is in Excel 2003 and appears to be a bug.

I have a cell with a large amount of text. Text wrapping has been enabled
and works fine for part of the cell. Eight lines down, it suddenly stops
wrapping and runs off the page. I've tried Paste Special off other cells to
correct this; turning off word wrap and turning it back on--I even tried
pasting it into a different cell with the same result. Nothing works except
to manually insert a carriage return, which is a big nuisance.

I don't know if it helps, but this problem starts at 164 words and and 960
characters.
--
Linda Adams
http://www.hackman-adams.com
http://www.david-hedison.com

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...7-4d62e742f343&dg=microsoft.public.excel.misc

 

[Dave Peterson]

If you add alt-enters (to force new lines in the cell) every 80-100 characters,
you should be able to see more characters.

 

[DNA]

I've seen this before in 2003, all I do is go between the cells, say
between rows 17 and 18, place my pointer directly in the middle of the two
rows directly on the left side of the page (i.e., between the actual row
numbers) until my pointer changes to the up/down arrow pointer and double
click.

This expands the row to allow for all of my text to show. I sometime have
to do this a few times, but not that often. Not sure what is in 2003...


HTH

 

[Guest]

Unfortunately, after it starts no longer wrapping, I have to do a hard return
at the end of every single line. This is a big nuisance on something where I
am constantly adding information and have to go back through and start adding
carriage returns so everyone can see the text.

 

[Guest]

I've tried this, too. The text still runs off the page and doesn't wrap.

 

[Dave Peterson]

I didn't say it wasn't irritating <bg>, I just said that alt-enters would fix
the problem.

Have you thought of using a textbox instead?

 

[Guest]

Hello Linda,
apparently, it's not a bug. I'm using the Dutch version, and it behaves
exactly the same way. I was looking in this forum, found your question and
someone else's.
the other person got an answer:
"From Excel's Help (search 'specifications')
Length of cell contents (text)
32,767 characters. Only 1,024 display in a cell; all 32,767 display in the
formula bar."
Apparently it's intentional, I haven't got the faintest clue why, but we'll
just have to live with it I supposte :-|
I'm going to try to figure out how to use the text box feature.
Menno.