length of character data
 

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.

==

Hi
1024 characters is the maximum for a cell to display. If you want to extend
this limit you may enter manual linebreaks with ALT+ENTER

--
Regards
Frank Kabel
Frankfurt, Germany

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.

==

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.

==