Find position of the first number in a cell, not working?

[Camel123]

Hi,

I am trying to return the minimum value of the position of all numbers in Mi Yang 1337

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

Using the above function gives 13 as result. It should be 9.

What is wrong?

 

[jmacleary]

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

 

[Phuoc]

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

 

[offthelip]

this bit of VBa will do it for you

Sub test()
Valt = Cells(1, 1)
lt = Len(Valt)
 For i = 1 To lt
  ch = Asc(Mid(Valt, i, 1))
  If ch > 47 And ch < 58 Then
  MsgBox (i)
  Exit For
  End If
  
 Next i
 
End Sub

you could use this as a UDF

 

[Camel123]

Tried both functions and the VBA. None of the suggested solutions above worked, unfortunately :/

I believe "," in my european or scandianvian version is "&", since "," only turns out in errors.

 

[jtakw]

Hi,

Not sure about your region requirements, but try changing All commas to semicolons:

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

OR

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

 

[Camel123]

None of the suggestions above works, only gives #VALUE ! error.

Please see link to picture

, this is how the function looks at the moment and the only one not giving error. Really frustrating...

https://imgur.com/a/qRF8KIt

 

[Tom.Jones]

See your pictures....

Why you use "&" instead ";" in your formula ???

Not sure about your region requirements, but try changing All commas to semicolons:

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

OR

=MIN(FIND({0;1;2;3;4;5;6;7;8;9};A2&1/17))

 

[Camel123]

See your pictures....

Why you use "&" instead ";" in your formula ???

Because using ";" in my Excel brings me to the next step in the function and gives errors, see img:
https://imgur.com/og02qby

 

[steve the fish]

Copy the below formula. Click cell B2. Go to the formula bar and paste in the formula. Press enter. What happens?

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