He realized a VCF file is just plain text with a special format. He added a new column called VCF_Formula . In cell E2, he typed this magic spell:
="BEGIN:VCARD"&CHAR(10)&"VERSION:3.0"&CHAR(10)&"FN:"&A2&" "&B2&CHAR(10)&"TEL:"&C2&CHAR(10)&"EMAIL:"&D2&CHAR(10)&"END:VCARD" how to create contacts vcf file from excel
Within seconds, all 300 parents were in his phone. He typed his group text, pasted the auction link, and hit send. He realized a VCF file is just plain
He needed a —a virtual business card file that phones understand. But how do you turn rows of text into digital contacts? pasted the auction link
Marco created a new column F. In F2, he wrote =E2 and copied it down—this forced Excel to save the formulas as values .
The School Auction Savior