Bhola Meena's Tech Knowledge Backup
Thursday, January 9, 2020
How to count words in sentence in excel file
Use below formula for it:
=
IF
(
LEN
(
TRIM
(
A4
)
)
=
0
,
0
,
LEN
(
TRIM
(
A4
)
)
-
LEN
(
SUBSTITUTE
(
A4
,
" "
,
""
)
)
+
1
)
Newer Posts
Older Posts
Home
Subscribe to:
Comments (Atom)
