trying to an IF function along with a MID in extracting numberswithing a string of both text and numbers.<o:p></o:p>
PBQ4X5 - using =MID(A2, SEARCH("Q",A2)+1, 1) to returnthe "4" and the same with "X" to return the numberassociated with it. Unfortunately when it runs across a sequence that...