I'd use:

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

The (A1<"") will only add 1 if a1 is not empty.

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)?

--

Dave Peterson