Thread: counting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default 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