excle中我怎么才能把答案提出到题目后面ABCD那种,魔题帮导入用?答:C2输入=IF(B2<>"",IF(B2<>A3,MID($A3,FIND("B、",$A3,1),IFERROR(FIND("C、",$A3,1)-FIND("B、",$A3,1),LEN(A3)-LEN(B2))),MID($A4,FIND("B、",$A4,1),IFERROR(FIND("C、",$A4,1)-FIND("B、",$A4,1),LEN(A4))),"") ,下拉D2输入=IF(B2<>"",IFERROR...