counting characters in a cell:return the number

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

Thanks.

=len(b1)



Glenn wrote:
>
> How can I have cell B2 return the number of characters in cell B1?
>
> Thanks.

--

Dave Peterson

Try typing this in B2:
= LEN(B1)


"Glenn" <[email protected]> wrote in message
news:ul1xHt%[email protected]...
> How can I have cell B2 return the number of characters in cell B1?
>
> Thanks.
>
>

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

"Glenn" <[email protected]> wrote in message
news:ul1xHt%[email protected]...
How can I have cell B2 return the number of characters in cell B1?

Thanks.