用WPS表格,或者exal,怎么可以把表格内容批量分开。宏吗?怎么操作,求带...答:如图一:在图二的“选项A”下一单元格中输入公式 =LEFT($E2,FIND("B",$E2)-2)“选项B”下输入 =MID($E2,FIND("B",$E2),FIND("C",$E2)-FIND("B",$E2))“选项C”下输入 =MID($E2,FIND("C",$E2),FIND("D",$E2)-FIND("C",$E2))“选项D”下输入 =MID($E2,FIND("D"...
excel怎么从题目中快速取出ABCD选项并填入单元格中?答:如图:B1用公式:=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A1,"A.",REPT(" ",200)&"A."),"B.",REPT(" ",200)&"B."),"C.",REPT(" ",200)&"C."),"D.",REPT(" ",200)&"D."),200*COLUMN(A1),200))右拉,下拉。