In what way do you intend SUM(LEN(A2)) to be different from LEN(A2) ?
In what way do you intend SUM(LEN(SUBSTITUTE(A2,"N",""))) to be different
from LEN(SUBSTITUTE(A2,"N","")) ?
Is there some use of the SUM function of which the rest of us are unaware?

Also, why the array formula? Where is the array? What would be different
if we just used enter instead of CSE?
--
David Biddulph

"francis" wrote in message
...
one other way with array formula, to be confirm by Ctrl,Shift and Enter

=SUM(LEN(A2))-SUM(LEN(SUBSTITUTE(A2,"N","")))/LEN("N")

This is case sensitive, it will return 0 if you put a "n" instead of "N"
in
your data.
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

"LiAD" wrote:

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