如何简化下试题？

高空闪电

如上图，只将ABCD中正确的选项保留，其余的删除，用公式可以实现吗？
整理试题.zip (12.69 KB, 下载次数: 7)

2018-3-30 14:13 上传

点击文件名下载附件

mmlzh

太扯蛋的数据，答案分隔符乱七八糟的，

1. =LEFT(B2,FIND("A",B2)-1)&RIGHT(B2,2)&TRIM(LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(B2,FIND(MID(B2,FIND("【",B2)+1,3)&".",SUBSTITUTE(SUBSTITUTE(B2,"．","."),"、","."))+1,99),"B",REPT(" ",100)),"C",REPT(" ",100)),"D",REPT(" ",100)),"【",REPT(" ",100)),100))

复制代码

LSL1128xgw

=LEFT(B2,FIND("A",B2)-1)&"【"&MID(LEFT(B2,FIND(CHAR(CODE(RIGHT(B2))+1)&".",SUBSTITUTE(ASC(LEFT(B2,LEN(B2)-2)&"E."),"、","."))-1),FIND(RIGHT(B2)&".",SUBSTITUTE(ASC(B2),"、",".")),99)

高空闪电

mmlzh 发表于 2018-3-30 14:57
太扯蛋的数据，答案分隔符乱七八糟的，

系统里导出来的就这样，我也没有办法。