例如:A1=511987198310252567 公式:=SUBSTITUTE(TEXT(--A1,"#,##0"),"000",RIGHT(A1,3)) 1,=SUBSTITUTE(TEXT(--"511987198310252567","#,##0"),"000",RIGHT(A1,3)) 2,=SUBSTITUTE(TEXT(511987198310252567,"#,##0"),"000",RIGHT(A1,3))“--”消除了文本格式数字 3,=SUBSTITUTE("511,987,198,310,252,000","000",RIGHT(A1,3)) 16、17、18变成0 4,=SUBSTITUTE("511,987,198,310,252,000","000","567")将000替换成567 5,=511,987,198,310,252,567 |