Counting number of particular characters in a cell

[LISAR]

Wondering if there is a function that will count the particular character in a cell
Example the cell contains "Martin Chooker" I want to know the number of "o" in the cell which the result would be 2.

 

[eliW]

On 2002-11-12 01:20, LISAR wrote:
Wondering if there is a function that will count the particular character in a cell
Example the cell contains "Martin Chooker" I want to know the number of "o" in the cell which the result would be 2.

Hi Lisar,Many ways to do this, one of them:

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

Eli