I used this formula to get it to work:-
=LOOKUP(10^6,1*MID(B2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B2&"0123456789",FIND("NBU"," "&B2&" "))),{2,3,4,5,6}))