counting characters in a cell

[Glenn]

How can I have cell B2 return the number of characters in cell B1?

Thanks.

 

[Dave Peterson]

=len(b1)

How can I have cell B2 return the number of characters in cell B1?

Thanks.

 

[Lewis Clark]

Try typing this in B2:
= LEN(B1)

 

[RagDyeR]

Do you consider <space> as a character?

If you *don't*, this is number of characters, not counting spaces:

=LEN(SUBSTITUTE(B1," ",""))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

How can I have cell B2 return the number of characters in cell B1?

Thanks.