Count the words in a cell

Premium

In B2, count the words in A2. There is one more word than there are spaces, and LEN(A2) minus the length without spaces, LEN(SUBSTITUTE(A2," ","")), is the number of spaces.

B2
ABCDEF
1Headline Words
2Fast free shipping on every order
3
4
5
6
7
8

Premium lesson

Unlock FIND and SEARCH and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:Joining text with & and TEXTJOINSUBSTITUTE, TEXTBEFORE and TEXTAFTER

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?