如题所述
用函数=SUBSTITUTE(A3,MID(A3,15,4),"****")
=IF((LEN(A1)>16),(LEFT(A1,6)&"******"&RIGHT(A1,4)),(LEFT(A1,6)&"******"&RIGHT(A1,3))).