Counting numbers in a single cell

[Rickmi]

I am trying to find a formula to count numbers in a single cell. I am able to achieve this but it counts numbers greater than 10 as 1 and 0. So if you had a list 1,2,3,4,5,6,7,8,9,10,11 it counts the number of digits, which totals 13 digits not 11 individual numbers. Can you assist?

 

[Marcelo Branco]

Welcome to Mr Excel forum

Try
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1

M.