Excel Function to Count

  • Thread starter Thread starter Renegade
  • Start date Start date
R

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.
 
Assuming a cell will not be empty and the character in the cell won't be a
comma...

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1
 
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...
Click to expand...

That should say:

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