How to find no.of characters in a cell?

  • Thread starter great whole sale club limited kolkatta
  • Start date
R

RagDyeR

If you're looking for an *actual character* count, and don't want to count
spaces,
Try this:

=LEN(SUBSTITUTE(A1," ",""))

--

HTH,

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

"great whole sale club limited kolkatta" <great whole sale club limited
kolkatta @discussions.microsoft.com> wrote in message
How to find no.of characters in a cell?
 
Top