Cell limitations?

  • Thread starter Thread starter JayL.
  • Start date Start date
J

JayL.

All,
Is there a cell limitaion for a formula in Excel 2000?

Also - is there a quick way to count the characters in a cell?


TIA!
 
Jay,

Cells can contain up to 32K characters, but only about 1000 can be displayed
in the cell. You can use the LEN function to return the number of characters
in a cell. E.g.,

=LEN(A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Hi JayL

Check out the Excel help
Length of formula contents 1,024 characters

=Len(a1) give you the characters
 
Left to its own devices, xl will show about 1000 characters in the cell.

But you can sprinkle a few alt-enters to force new lines within the cell and see
more.

(Remember that with merged cells, you'll have to adjust the rowheight
manually--autofit doesn't work.)
 
Back
Top