If there will always be at least one number within the text string,
try...

=MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789"))

Otherwise, try...

=IF(OR(ISNUMBER(FIND({0,1,2,3,4,5,6,7,8,9},A2))),M IN(FIND({0,1,2,3,4,5,6,
7,8,9},A2&"0123456789")),"")

Hope this helps!

In article ,
lovemuch wrote:

The cell's text is:
Reclassed to 101-001-4455-003.
I want to find the position of the first number, which in this case would be
the number "1" and it would be in the 14th place (if I counted right!). The
text will vary, so the locate of the number will vary, and the number itself
will vary.

I should be able to figure this out, but it's become like looking at your
best friend and not being able to remember their name!

Thanks for anyone's assistance!

Yours truly.....Cynthia :-)