In my base I have a list of my customers by phone number. We are trying to link if they attended a zoom session. I have a script that can link if it find name or phone number matches. Sometimes though customers dial in by phone. Registration reports from zoom provide numbers in a string of digits with a country code at the front.
Ex. (123) 456 - 7890 would show up as 11234567890
For my script to work I need to have the two columns that have the same values. Is there a way to format using formulas either column to make them match. Any ideas?