Counting Words in a Cell in Excel 2007-2013

Counting Words in a Cell in Excel 2007-2013

 

The formula below will return the number of words (not characters) in cell A1
=LEN(A1)-LEN(SUBSTITUTE(A1,” “,””))+1

This basically figure out how many characters there are, counts how many spaces there are, subtracts them and adds 1

This is covered in our Excel Power Users Formula Class