excel如何把一个单元格内一个数据对应另一个一个单元格多个数据拆分开一...答:在C1 D1分别输入或复制粘贴下列公式 =IF(ROW(A1)<=1+SUMPRODUCT(LEN(B$1)-LEN(SUBSTITUTE(B$1,",",))),INDEX(A:A,1+INT((ROW(A1)-1)/(1+SUMPRODUCT(LEN(B$1)-LEN(SUBSTITUTE(B$1,",",))),"")=IF(ROW(A1)<=1+SUMPRODUCT(LEN(B$1)-LEN(SUBSTITUTE(B$1,",",))),MID...