B2{=SUBSTITUTE(A2,LOOKUP(1,0/MID(A2,SUM(IF(ISNUMBER(-MID(A2,ROW($1:$98),1))*(MID(A2,ROW($2:$99),1)="鄰"),ROW($1:$98)))-{0,1,2,3},{1,2,3,4}),MID(A2,SUM(IF(ISNUMBER(-MID(A2,ROW($1:$98),1))*(MID(A2,ROW($2:$99),1)="鄰"),ROW($1:$98)))-{0,1,2,3},{1,2,3,4}))&"鄰",)
留言
張貼留言