202110040951電話自動隔開區碼 (8915)

C2 下拉=IF(B2="","",REPLACE(B2,LOOKUP(1,0/MATCH(LEFT(B2,{2,3,4}),K$2:K$13,),{3,4,5}),,"-"))

另解=IF(B2="","",REPLACE(B2,LOOKUP(1,0/(FIND(K$2:K$13,B2)=1),LEN(K$2:K$13)+1),,"-"))

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank