Thanks for all the help. I understand the sumproduct now and how the
substitute is working. Very Cool.

I still dont get why - 9 and * the length works.

Still confused in Phoenix. Thanks for all the help, I really appreciate it.

"Jordan" wrote:

Can anyone tell me why this formula works. It was given to me as a solution
and it works I just dont understand why.

I was trying to count how many charaters in a cell are letters.

For example JXR1234 = 3

=SUMPRODUCT(LEN(SUBSTITUTE(A22,{0;1;2;3;4;5;6;7;8; 9},"")))-9*LEN(A22)

I understand how sumproduct works, just not in this instance.

Thanks for any help you can send my way.

Confused in Phoenix.