MrExcel Publishing
Your One Stop for Excel Tips & Solutions

despite increased character limitation, my cell only holds 1200 characters

Posted by Christine on May 16, 2001 11:52 AM

I type information into a merged cell set to word wrap. It works great, up to about 1200 characters, and then even though the complete text shows in the formula bar, when you enter the text, only the 1200 characters show up in the cell, with lots of space below it. I even tried copying the value of an identical cell to override the 1200 character copy limitation, and it does the same thing.

Does anyone have a solution?


Posted by Mark W. on May 16, 2001 2:04 PM

Christine, there's a maximum row height of 409.

Posted by Mark W. on May 16, 2001 2:20 PM


The output from =REPT(REPT("1234567890",10)&CHAR(10),20)
fits in a cell sized to 255 x 100 (height x width). You'll
notice that this formula employees a "hard" wrap, CHAR(10),
which is the same as Alt+Enter.

Posted by Christine on May 18, 2001 6:42 AM

Mark, can you give me more assistance?

Mark, thanks for the infor, but I still need help figuring out how to do what I need to do. I tried your formula, and it didn't work for me. And I tried resizing the cell, and that didn't work. Right now, I have several cells merged to get an input box the size I need. Can you help me out if I give you more specifics?

Thanks, Christine