Excel総合相談所 89

>>154-155
B1の式をちょちょっとアレンジすればおＫ。↓

=MID(D1,MIN(FIND({"A","B","C","D","E"},D1&"ABCDE"))-1,2)