excel在A和0之间加一个“—”的公式,看图片数据还有就是AB和0之间,ABC与0之间等谢谢
è§æ ·è¡¨æªå¾
B1è¾å ¥
=IF(LEFT(A1,2)="A0",SUBSTITUTE(A1,"A0","A-0"),IF(LEFT(A1,3)="AB0",SUBSTITUTE(A1,"AB0","AB-0"),IF(LEFT(A1,4)="ABC0",SUBSTITUTE(A1,"ABC0","ABC-0"),"")))
å ¬å¼ä¸æ
å¤å¶Bå>å³é®>éæ©æ§ç²è´´>æ°å¼
å é¤Aåï¼OK.