1.如果i2中有“.”,则执行g2&i2,否则执行g2 =IF(COUNTIF(I2,"*.*")>0,G2&I2,G2) 2.把j4中的k4&"."替换为"" =SUBSTITUTE(J4,K4&".","")