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

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

--
Biff
Microsoft Excel MVP


"Renegade" wrote in message
...
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.