CSV to VCARD
Lihat video dibawah untuk step by step bagaimana nak rename ribuan no dan save ke telephone dengan mudah.
p/s: Boleh klik tulisan YouTube untuk besarkan video (lihat di Youtube)
Formula excel tukar format tel ke 601xxxxxxxx
=IF(LEFT(A6,1)="0",CONCATENATE("6",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A6," ",""),"-",""),"+","")),IF(OR(ISNUMBER(SEARCH(" ",A6)),ISNUMBER(SEARCH("-",A6)),ISNUMBER(SEARCH("+",A6))),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A6," ",""),"-",""),"+",""),IF(OR(LEFT(A6,1)="0",LEFT(A6,1)="6"),A6,CONCATENATE("60",A6))))
----------
Formula tukar no tel 60xxxxxxx ke +60xxxxxx
="+"&B6
--------
=IF(LEFT(A6,1)="0",CONCATENATE("6",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A6," ",""),"-",""),"+","")),IF(OR(ISNUMBER(SEARCH(" ",A6)),ISNUMBER(SEARCH("-",A6)),ISNUMBER(SEARCH("+",A6))),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A6," ",""),"-",""),"+",""),IF(OR(LEFT(A6,1)="0",LEFT(A6,1)="6"),A6,CONCATENATE("60",A6))))
----------
Formula tukar no tel 60xxxxxxx ke +60xxxxxx
="+"&B6
--------