=IF(A1="",0,LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1)

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

For comma separated values

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

If this post helps click Yes
---------------
Jacob Skaria


"backmara" wrote:

I need to know how many numbers are in the same cell.
Example:
A1 inculdes 12,23,34,45
How I calculating this numbers(Answer:4)?