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

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

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

Hi,

You can also try this array formula (Ctrl+Shift+Enter)

=SUM(1*(MID($D$13,ROW(INDIRECT("1:"&LEN(D13))),1)= "N"))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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