# 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 <gavee.2746$5o2.2091@newssvr13.news.prodigy.com>,
"gbeard" <gbeard12@sbcglobal.net> 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.