excel里如何将一个单元格里的内容拆成多个,并且复制同一行内容到下一行...答:如果P列每个单元格的数据个数是相同的则公式可以如下 A1单元格输入公式 =TRIM(MID(SUBSTITUTE(OFFSET(P$1,INT((ROW(A1)-1)/(LEN(P$1)-LEN(SUBSTITUTE(P$1,",",""))+1)),),",",REPT(" ",99)),(1+MOD(ROW(A1)-1,LEN(P$1)-LEN(SUBSTITUTE(P$1,",",""))+1))*100-99,...