Cell limitations?

[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!

 

[Chip Pearson]

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)

 

[Ron de Bruin]

Hi JayL

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

=Len(a1) give you the characters

 

[Dave Peterson]

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.)