DW联系人2.2.6已付费版
=IF(ROW()=2,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A3,"TEL;TYPE=CELL;TYPE=PREF:",""),"-",""),"+86",""),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(INDIRECT("A"&ROW;()+5*(ROW(A1)-1)+1),"TEL;TYPE=CELL;TYPE=PREF:",""),"-",""),"+86",""))
下载地址
用户评论
可以设群组铃声、拨号器上搜索联系人很方便