Excel Function to Count
 

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.

Excel Function to Count
 

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.

Excel Function to Count
 

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...

--
Biff
Microsoft Excel MVP


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