If you want to count both upper and lower case letters as being the same:

1 2n4 N8 0,4xFN9n

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

Count of N + n = 4

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

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

Note that this is case sensitive. The above will not count lower case n.

--
Biff
Microsoft Excel MVP


"LiAD" wrote in message
...
Hi,

Is it possible to count how many times a letters appears in a text
string.
Example

1 234 N8 0,4xF9

I would like a formula that gives me the result of 1 as N only appears
once.

Is this possible?
Thanks