Wrap Text Problem

[papaexcel]

See attached file. I want the entire text wrapped to fit in the cell and I'm not sure why it's not working. It only wraps part of it.

Also, I know there is a character limit in a cell, but how does merging cells effect that limit?

Thanks in advance

[martindwilson]

i'd like a ferrari , but that doesn't alter excels parmeters

[papaexcel]

Not a very helpful answer. Maybe my question should have been more specific....what excel parameter is responsible for constraining my text?

[shg]

Sans line feeds, Excel will not display more than about 1k characters in a cell.

Move some of the text to another cell.

[papaexcel]

Can't move the text to another cell.

But I find that answer unsatisfactory as well. If I increase the column width, more text displays. I can actually make the columns wide enough to display all of the text. But that isn't a practical solution either. So I still don't have a good understanding of how excel determines cell limits.

I also don't know how line feeds would alter anything.

[shg]

Interspersed line feeds allow Excel to display a lot more characters.

Good luck.

[papaexcel]

Thanks for the tip. That did help.

Now if anyone can explain excel's rationale for determining cell size, I would be grateful.

And how merging cells effect the cell's limit.

Again, thanks in advance.

[martindwilson]

Not a very helpful answer

sorry mate but that's the best i can do
can't help it if you want do something outside what the application wants to do