close

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?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()