EXCEL如何按条件拆分单元格内容答:C1公式下拉:=IF(A1="","",SUBSTITUTE(LEFT(A1,FIND("C",A1)-1),B1,))D1公式下拉:=IF(A1="","",SUBSTITUTE(LEFT(A1,FIND("D",A1)-1),B1&C1,))E1公式下拉:=IF(A1="","",SUBSTITUTE(A1,B1&C1&D1,))如果完成后不想要原A列的的内容,可这样操作:选中B、C、D、E共4列--...
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,...