电话中间四位数保密 (11133)

B2下拉{=IFERROR(REPLACE(IF(ROW(A1)=1,A2,B1),SMALL(IF(ISERR(-MID(A$2,ROW($1:$98),1))*ISNUMBER(-MID(A$2,ROW($2:$99),1)),ROW($1:$98)),ROW(A1))+4,4,"****"),"")

A8=LOOKUP(1,0/(B2:B9<>""),B2:B9)