Assuming every cell will contain a number:

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

--
Biff
Microsoft Excel MVP


"samuel" wrote in message
...
I have several cells

text text 232
text more text 80908

I want a formula to find the location of the first occurance of a number.

something like find(#,a1)