Text in a cell

  • Thread starter Thread starter Steve
  • Start date Start date
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.
 
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
 
Try adding some alt-enters to force new lines within the cell.

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