Counting Within a Cell

[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

 

[RichardSchollar]

Hi Tom

Something like this will work:

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

Best regards

Richard

 

[Tom G]

Hi Tom

Something like this will work:

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

Best regards

Richard

Thanks, did the trick.