Not all pasted text appears in cells

C

cjswift

I am pasting large amounts of text from Word into Excel. At times not all
the text appears in the cell, but the full text shows in the formula bar.
How can I show all the text that is in the formula bar?
 
E

Earl Kiosterud

CJ,

Unless you've interspered some line feeds (chr(10) or pressing Alt-Enter) in
the text, only 1024 characters appear in the cell, even though it can hold
32,768 characters.
 
Top