• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 42
  • Last Modified:

count number of words

i need to count the number of words in each cell that are comma separated

example

analysis, engagements, initiatives, scale
Awards, exclusive, national, retail, stores stores, Voted
convergence, enterprises, partnership, partnership
edge, Profit
0
finnstone
Asked:
finnstone
1 Solution
 
NorieVBA ExpertCommented:
If the words were in column A starting in row 1 try this formula in B1 and copy it down.

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1
1
 
Rob HensonFinance AnalystCommented:
In case the last word is followed by a comma:

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+IF(RIGHT(A1,1)=",",0,1)
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now