How to find no.of characters in a cell?
 

How to find no.of characters in a cell?

How to find no.of characters in a cell?
 

=LEN(A1)
--
Brevity is the soul of wit.


"great whole sale club limited kolkatta" wrote:

How to find no.of characters in a cell?

How to find no.of characters in a cell?
 

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?