I'm trying have a large text field in an excel file. After about 10 - 12
lines the text no longer wraps. My Excel book said each cell holds about
32,000 characters, my text is less than 2,000 characters (with spaces). Any
ideas?
The Excel book is right......you can enter 32,767 characters in a cell.
What the book did not explain is that only 1024 or those characters can be seen
or printed.
Stick in an ALT ENTER(carriage return) about every 100 characters and you can
expand the 1024 limit by at least 4 or 5 times.Gord Dibben MS Excel MVP
On Fri, 13 Jan 2006 12:43:02 -0800, quot;STLVickiquot;
gt; wrote:
gt;I'm trying have a large text field in an excel file. After about 10 - 12
gt;lines the text no longer wraps. My Excel book said each cell holds about
gt;32,000 characters, my text is less than 2,000 characters (with spaces). Any
gt;ideas?
- Nov 18 Sat 2006 20:10
The wrap text feature stops after 10
close
全站熱搜
留言列表
發表留言