View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.