search string for number value
 

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)

search string for number value
 

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)

search string for number value
 

Ctrl/Shift/Enter this:
=MATCH(FALSE,ISERROR(1*MID(A1,ROW(1:100),1)),0)
In your example this returns 11.

HTH
Bob Umlas
Excel MVP

"samuel" wrote:

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)

search string for number value
 

On Tue, 13 May 2008 13:19:03 -0700, samuel
wrote:

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)


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

And, if you want to return that number:

=LOOKUP(9.9E+307,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"
0123456789")),ROW(INDIRECT("1:"&LEN(A1)))))
--ron