-
张3
发布于 2026-05-15
-
收藏
另外一种办法:假设你的数据是从A1 开始 那么你可以在B1输入:=TEXT(LEFT(A1,SEARCH("-",A1)-1),"00-")&TEXT(LEFT(SUBSTITUTE(A1,LEFT(A1,SEARCH("-",A1)),"",1),SEARCH("-",SUBSTITUTE(A1,LEFT(A1,SEARCH("-",A1)),"",1))-1),"00-")&TEXT(SUBSTITUTE(SUBSTITUTE(A1,LEFT(A1...