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


"JayL." wrote in message
news:0hApb.74478$9E1.332247@attbi_s52...
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!

Hi JayL

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

=Len(a1) give you the characters

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"JayL." wrote in message news:0hApb.74478$9E1.332247@attbi_s52...
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!

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

"JayL." wrote:

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!

--

Dave Peterson