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",""))