This formula is designed to extract asset numbers from monitors (a) and computer numbers (b) after the help desk program dumps summary fields. First is goes through and looks for the monitors and if it doesn’t find any the error function runs the search for computers. The trick is that not only numbers are returned but words as well so after you put the formula in you have to do replaceall to change the words to nothing.
=IF(ISERROR(MID(D1,SEARCH(“a?????**”, D1),8)),(MID(D1,SEARCH(“b?????**”, D1),8)),(MID(D1,SEARCH(“a?????**”, D1),8)))