L
Leezo
could anyone tell me the formula for counting charachters in a cell
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Domenic
Leezo said:could anyone tell me the formula for counting charachters in a cell
Try...
=LEN(A1)
Hope this helps!
M
Markos Mellos
=LEN("cell")
B
BizMark
Markos said:=LEN("cell")
:
-
could anyone tell me the formula for counting charachters in a cell-
WARNING!!!! For counting the length of the contents of a cell, yo
don't use quotes, just the cell reference
G
Gary's Student
Just remember that LEN() reports the length of the answer for a formula, not
the length of the formula itself.
the length of the formula itself.
M
Markos Mellos
Of course BizMark. I only used the quotes to indicate that "cell" should be
replaced with the desired cell. Sorry for any confussion it might have caused.
replaced with the desired cell. Sorry for any confussion it might have caused.