# of occurrences

gbeard · May 5, 2005

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,

JE McGimpsey · May 5, 2005

One way:

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