counting

A

Alex

I'd like to know if you can count words inside of a cell that are separated
by a comma. For example, if i have N,S inside of a cell, I'd want a count of
2. If i had NA,S - i would still want a count of 2. NA,S,C - i would want a
count of 3. Please let me know if this is possible and how.

Thank you
Alex
 
G

Gary''s Student

Count the number of commas and add one:

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