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.
Bookmarks