Excel experts may have more elegant suggestions for you.
Anyway, you could try the following formula (which assumes that the string
is in A1. Change it appropriately.

=FIND(1,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUT E(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBS TITUTE(A1,2,1),3,1),4,1),5,1),6,1),7,1),8,1),9,1), 0,1))

Best regards,
B. R. Ramachandran



"Thomas M." wrote:

Excel 2007

Is there a way to find the position of the first digit within a text string?

--Tom