Text in a cell

S

Steve

Are there limits to the amount of text allowed in a cell?

If so how do I get rid of the limits?

I have typed information in a cell and all of it is there
but it does not show up and cuts it off.

Thanks.
 
F

Frank Kabel

Hi
have a look at the Excel helpfile (search for 'Specification):
- allowed: 32767 characters
- only the first 1024 are shown in you cell / all characters are shown
in the formula bar

And no there is no way to get over this limit
 
D

Dave Peterson

Try adding some alt-enters to force new lines within the cell.

You'll be able to see (lots) more.
 
Top