NON-VBA: FORMULA NEEDED - Looping through string and stop on non-numeric

Originally Posted by XOR LX

Bit messy, and perhaps not guaranteed to always work. Try, in C2:

=LOOKUP(2^15,SEARCH(D2,$G$2:$G$5),$H$2:$H$5)

though I don't know where you get your expected result for 05FIAJ100051144 from. There's nothing in your table remotely like it.

Regards

No...that's perfect!!! Thanks once again for your help!