To Create Contacts Vcf File From Excel [upd]: How

BEGIN:VCARD VERSION:3.0 FN;CHARSET=UTF-8:John Doe N;CHARSET=UTF-8:Doe;John;;; EMAIL;TYPE=WORK,INTERNET:john.doe@example.com TEL;TYPE=WORK:+1 123 4567890 ADR;TYPE=WORK:123 Street, City, State, Zip END:VCARD

He then:

Marco created a new column F. In F2, he wrote =E2 and copied it down—this forced Excel to save the formulas as values . how to create contacts vcf file from excel

He needed a —a virtual business card file that phones understand. But how do you turn rows of text into digital contacts? BEGIN:VCARD VERSION:3