Counting Commas in a cell in Excel X

D

Debra Berry

I have some lengthy lists contained in Excel cells, and it would be really
handy for me if there were a way to count list items in some of those cells.
As the items are separated by commas, I figured the easiest way to get that
count would be to count the number of commas in that cell and add one, but I
can't figure out how to do this; I don't see a function that give me this.

Any help would be much appreciated!

Debra Berry
 
J

JE McGimpsey

Debra Berry <[email protected]> said:
I have some lengthy lists contained in Excel cells, and it would be really
handy for me if there were a way to count list items in some of those cells.
As the items are separated by commas, I figured the easiest way to get that
count would be to count the number of commas in that cell and add one, but I
can't figure out how to do this; I don't see a function that give me this.
Click to expand...

One way:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Counting items in a cell 3
Adding Cost Field to Appointment 0
How to count commas in a cell? 5
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Counting the number of unique different values in a set 2
Excel Function to Count 2
LINEST containing selection 0

Top