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?

 

[Camel123]

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"))

This happens:
https://imgur.com/a/lg4GNVq
and if accepting then= #VALUE !

If I click no, then this happens:
https://imgur.com/a/tnQizPm

 

[steve the fish]

If you replace the commas with semicolons then what happens?

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

 

[Camel123]

If you replace the commas with semicolons then what happens?

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

Omg it works! I don't know what stupid mistake I did when I tried it first but thanks a lot to you all!

 

[Tom.Jones]

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

In the attached picture what should I see ???

At least you tried?

Copy one of the formulas and paste into the cell where you need it, and you will see it work.

= 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))

 

[jtakw]

Omg it works! I don't know what stupid mistake I did when I tried it first but thanks a lot to you all!

You're welcome, glad you got it working.

Didn't I already made that suggestion back in Post # 6?