I tried this formula:

=AGGREGATE(14,6,FIND({1,2,3,4,5,6,7,8,9,0},A1,ROW(INDIRECT("1:"&LEN(A1)))),1)

For example text string is "A111" it should return 4. Now it returns 2.

I don't want to use array entry (crtl+shift+enter). I need the position to use the formula within another formula. Can someone help me with the formula?

Thank you in advance.

## Bookmarks