Cell limitations?
 

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!

Cell limitations?
 

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!

Cell limitations?
 

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!

Cell limitations?
 

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