Excel中用函数公式将原数据中单个单元格内多组数据自动分别分列填入指 ...答:在D3和E3中分别输入或复制粘贴下列公式 =LEFT(TRIM(MID(SUBSTITUTE($C3," ",REPT(" ",100)),INT(COLUMN(B:B)/2)*100-99,100)),LENB(TRIM(MID(SUBSTITUTE($C3," ",REPT(" ",100)),INT(COLUMN(B:B)/2)*100-99,100)))-LEN(TRIM(MID(SUBSTITUTE($C3," ",REPT(" ",100)),INT...