In Excel, how can I show very long text in a single cell?
Add an Alt + Enter for a linefeed every 100 or so characters.
Excel's specs state you can enter 32767 characters in a cell but only 1024 will
be visible or can be printed.
Adding the linefeeds extends that 1024 limit.
Gord Dibben MS Excel MVP
On Tue, 20 May 2008 15:40:21 -0700, Noreen
wrote:
I'm using WRAP TEXT but the data in the cell is truncated. I can see the
entire entry in the formula window, but not in the cell.
|