How to count a character in a cell?

[maheshmaxi]

Hi,

I have two queries:

1. How to count a particular character in a cell?
2. How to count number of words in a cell?

Pls help me on this.

 

[njimack]

To count how many times the letter a is in cell A1: =LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))

To count no. of words in A1: =LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1

 

[maheshmaxi]

Awesome and simple Neil!

Thanks a ton!!