把excel两列字符数据用逗号合并起来 =CONCATENATE(I2,IF(OR(ISBLANK(I2),ISBLANK(J2)),"",","),J2) 例如 ---I2-------J2----- 01,02,03 09