C
CPAZO
How do i set up wordcount within cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Try
=LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1
Mike
=LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1
Mike
T
Teethless mama
=LEN(A1)
D
Dave Peterson
If the words are separated by spaces:
=LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+(TRIM(A1)<>"")
=LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+(TRIM(A1)<>"")
J
John C
And if I have 2 words in the cell?
Borrowing from Mike's solutions:
=IF(A1="",0,LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+1)
Borrowing from Mike's solutions:
=IF(A1="",0,LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+1)