Excel Function to Count

[Renegade]

I have a list of items in various cells in a spreadsheet. For example
(April, May, June, July) as a group in one cell ,and I want to obtain an
actual count of the items in this cell. Is there a way to achieve this
without physically counting each item which has been seprated by a comma? In
my example above, the total count would be (4). Any ideas would be greatly
appreciated.

 

[T. Valko]

Assuming a cell will not be empty and the character in the cell won't be a
comma...

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

 

[T. Valko]

It's too early for me!

Left out a word that's critical to my caveat:

Assuming a cell will not be empty and the character
in the cell won't be a comma...

That should say:

Assuming a cell will not be empty and the LAST character in the cell won't
be a comma...