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