Count Words in Single Cell
=LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1
© Copyright
andrewsexceltips.net
All Rights Reserved.