View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

32,767 is the number of characters that can be entered in a cell.

However......only 1024 of these will display.

The maximum width of a column is 255 characters, so word wrap must be enabled
to see the full 1024.

See Frank's post for a partial work-around using ALT + ENTER.

Gord Dibben Excel MVP

On 19 Dec 2004 04:20:16 -0800, (Saravanan) wrote:

If I keep typing all characters in a cell, how many
characters can a cell contain ?
In other words , a line in a cell can contain how many
characters ?

Thanks.

==