counting
 

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

counting
 

Count the number of commas and add one:

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

--
Gary''s Student - gsnu200779


"Alex" wrote:

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

counting
 

Maybe

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

Mike

"Alex" wrote:

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