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