Counting Within a Cell

  • Thread starter Thread starter Tom G
  • Start date Start date
T

Tom G

Hi,

How do I count the number of digits within a cell.

4,5,6,7

The answer should be four. I don't want to count the commas.

Thanks,

Tom G
 
Hi Tom

Something like this will work:

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

Best regards

Richard
 
Back
Top