Search for numbers in a cell that also contains text

Hi guys,

I can't solve a problem. I need to search for 2 numbers in a cell contains both
text and numbers.

I need to find the two first numbers after the letters,
example:
BFT01777 need to return "01" (three letters in the start)
BF018888 need to return "01" also (but now two letters in the start).

Is this possible?

Thanx, it works with two letters in the start, but not three.
What if there also are 4 letters in the beginning?

Originally Posted by Bryan Hessey

Hi,

if the two forms shown are the only formats then

=IF(ISNUMBER(MID(A1,3,1)+0),MID(A1,3,2),MID(A1,4,2))

should do that.

---

Sorry Bryan, it works perfect with three letters too :-)

Originally Posted by Bryan Hessey

Hi,

if the two forms shown are the only formats then

=IF(ISNUMBER(MID(A1,3,1)+0),MID(A1,3,2),MID(A1,4,2))

should do that.

---

but the IF formula does not work with 4 letters. How can that be solved?

I see. Thanx for all the help, Bryan

Originally Posted by Bryan Hessey

4 what letters? - would you care to explain
---
if you mean 4 letters preceeding the number then

=IF(ISNUMBER(MID(A1,3,1)+0),MID(A1,3,2),IF(ISNUMBER(MID(A1,4,1)+0),MID(A1,4,2),IF(ISNUMBER(MID(A1,5,1)+0),MID(A1,5,2),MID(A1,6,2))))

and add new 'If' as required

---