count number of words

finnstone used Ask the Experts™
i need to count the number of words in each cell that are comma separated


analysis, engagements, initiatives, scale
Awards, exclusive, national, retail, stores stores, Voted
convergence, enterprises, partnership, partnership
edge, Profit
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Analyst Assistant
If the words were in column A starting in row 1 try this formula in B1 and copy it down.

Rob HensonFinance Analyst

In case the last word is followed by a comma:


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial