Paul,

use TRIM to try to enforce your assumptions.

Pete

On Aug 15, 2:49 pm, "PCLIVE" wrote:
With the assumption that each word is separated by only one (1) space with
no spaces at the beginning or at the end, then you could use the following
formula.

=(LEN(A1)-LEN(SUBSTITUTE(A1," ","")))+1

HTH,
Paul

--

wrote in message

ups.com...



Is there a way to count the number of words in just a cell? If so,
how?

Thanks
Samantha- Hide quoted text -

- Show quoted text -