=LEN(A1)-SUMPRODUCT(--ISNUMBER(-RIGHT(A1,ROW(INDIRECT("1:"&LEN(A1)))))

will tell you the number of text characters in the cell


"Jordan" wrote in message
...
I have a cell that has a mix a text and numbers. I need to know how many
of
the charaters are text and how many are numbers. It usually is something
like JDR89765 or JD5674, meaning that the text is on the left side. If
possible I would like to read from left to right and get a count of how
many
text char there are before the first number.

Any help will be greatly appreciated.

Thanks in advance.