如题所述
在E列插入一列“添加答案的题目列”,在E2单元格输入以下公式,然后向下填充公式
=SUBSTITUTE(D2," ",TRIM(MID(SUBSTITUTE(F2," ",REPT(" ",100)),1+(CODE(G2)-65)*100,100)))
详见附图示例