CSV to VCARD



DOWNLOAD SINI
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


--------


Back
🔥Power by INIBIOLINK