find a number in a cell

[T. Valko]

Yeah, that'll work. I didn't have time to dig any deeper and look for a
tweak.

 

[Rick Rothstein \(MVP - VB\)]

I'm not 100% sure why this works, but it does seem to work. This formula
removes one of the SUBSTITUTE function calls and arrays the "find me" text
(saving some 15 characters in the process)... and it seems to always return
the correct answer too:

=LOOKUP(1000,--MID(SUBSTITUTE(LOWER(A1),{"a","p"},"z"),MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&{0,1,2,3,4,5,6,7,8,9},SEARCH("
at ",A1))),ROW(INDIRECT("1:255"))))

Rick