请教,Excel中如何提取多个单元格内容中相同的部分?答:如果能加辅助列,可以简单点 1、提取每个单元格第一组数据。E1=TRIM(MID(SUBSTITUTE(A1,"、"," "),1,10))2、提取第二组。I1=TRIM(MID(SUBSTITUTE(A1,"、"," "),10,10))3、提取第三组。M1=TRIM(MID(SUBSTITUTE(A1,"、"," "),26,10))最后对比数据,显示结果:Q1=IF(AND(...
请问如何通过公式提取单元格内的部分内容?答:如图,E2单元格输入公式=IF(LEFT(E1,2)="上班",RIGHT(MID($C2,1,FIND("@",SUBSTITUTE($C2,"-","@",COUNTIF($E1:E1,E1)))-1),5),LEFT(MID($C2,FIND("@",SUBSTITUTE($C2,"-","@",COUNTIF($E1:E1,E1)))+1,99),5))右拉公式。示例 ...