Tom’s Tutorials For Excel: Counting Words in a Sentence or String

Tom’s Tutorials For Excel: Counting Words in a Sentence or String

Here is a formula to count the words in a sentence or string of text.
=IF(LEN(A2)=0,0,LEN(A2)-LEN(SUBSTITUTE(A2, " ", ""))+1)

The SUBSTITUTE function handles the possibility of the cell containing no text or value.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,
One comment on “Tom’s Tutorials For Excel: Counting Words in a Sentence or String
  1. Tudor says:

    very-useful. ty

Leave a Reply

Your email address will not be published. Required fields are marked *

*