# of occurrences

Is it possible to count how many times a space occurs in a cell? If I could
count the words in a cell...that would work as well.

Thanks,

--
Gary Beard

One way:

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

In article <[email protected]>,
"gbeard" <[email protected]> wrote:

> Is it possible to count how many times a space occurs in a cell? If I could
> count the words in a cell...that would work as well.