[FONT="]trying to an IF function along with a MID in extracting numberswithing a string of both text and numbers.<o></o>[/FONT]
[FONT="]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 doesn'tinclude either the X or the Q (PBI5G3), I get "#VALUE!". I also get"#VALUE when trying to "sum" the number columns that the formulareturns. Trying to come up with an IF formula to incorporate with the MID andSEARCH so that it will return a "0" when it can't find the particulartext (Q or X). Any help would be appreciated, I've been working on this forquite a while.<o></o>[/FONT]
[FONT="]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 doesn'tinclude either the X or the Q (PBI5G3), I get "#VALUE!". I also get"#VALUE when trying to "sum" the number columns that the formulareturns. Trying to come up with an IF formula to incorporate with the MID andSEARCH so that it will return a "0" when it can't find the particulartext (Q or X). Any help would be appreciated, I've been working on this forquite a while.<o></o>[/FONT]