如题所述
是数字型
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,LEFT(B1,1),""),MID(B1,2,1),""),MID(B1,3,1),""),MID(B1,4,1),""),MID(B1,5,1),""),MID(B1,6,1),"")试了一下,下面这个公式可以实现你的要求