第1个回答 2015-12-11
B1=MID(A1,SMALL(IF((CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))>64)*(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))<123),ROW(INDIRECT("1:"&LEN(A1))),""),1),LARGE(IF((CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))>64)*(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))<123),ROW(INDIRECT("1:"&LEN(A1))),""),1)-SMALL(IF((CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))>64)*(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))<123),ROW(INDIRECT("1:"&LEN(A1))),""),1)+1)本回答被网友采纳