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?