=IF(AND(OR(LEN(C2)=8,LEN(C2)=7),OR(ISNUMBER(SEARCH("o",LEFT(C2,1),1)),ISNUMBER(SEARCH("e",LEFT(C2,1),1)))),SUBSTITUTE(C2,C2,"-"),IF(AND(LEFT(C2,4)="BAV(",OR(LEN(C2)=12,LEN(C2)=11),OR(ISNUMBER(SEARCH("o",MID(C2,5,1),1)),ISNUMBER(SEARCH("e",MID(C2,5,1),1)))),SUBSTITUTE(C2,C2,"BAV"),C2))
Formula not working...no end result