Limitations to the number of characters in a merged cell??

Hello,

I know that a cell in Excel has a limitation to the number of characters it can hold and display at once, but this is killing me! I work for a bunch of hard headed folks who insist on trying to use Excel like an MS Word document and they want to populate a cell with a composition!!! I have created a huge block consisting of Merged cells and it still only seems to allow so much entered. Also, even with text wrap selected, it cust off words on the right too. And when you are typoing in the box,...you see your text all the way to the bottom but when you are finished,...only the upper half of the text in the box is visible and the bottom half is empty...weird!!!

I was thinking of just having a HUGE text box in a second worksheet and have the first box on sheet 1 simply link up so that it can be all visible in the
2nd box in sheet 2...

Is there any other way to deal with this? Is there an actual text box that can hold a near infinate amount of text????

Here's a link on the limitations of text in a cell

http://www.contextures.com/xlfaqApp.html#CharInCell