混编提取数字和字母

nnsea

IFERROR(LEFT(LEFT(RIGHTB(E3,LENB(E3)-SEARCHB("?",E3)+1),FIND(";",RIGHTB(E3,LENB(E3)-SEARCHB("?",E3)+1))-1),2*LEN(LEFT(RIGHTB(E3,LENB(E3)-SEARCHB("?",E3)+1),FIND(";",RIGHTB(E3,LENB(E3)-SEARCHB("?",E3)+1))-1))-LENB(LEFT(RIGHTB(E3,LENB(E3)-SEARCHB("?",E3)+1),FIND(";",RIGHTB(E3,LENB(E3)-SEARCHB("?",E3)+1))-1))-0),"")