Wednesday, November 2, 2011
Count Words in a Cell, Excel Formula
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment