counting characters in a cell

  • Thread starter Thread starter Glenn
  • Start date Start date
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.
 
Back
Top