This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I’m pretty new to Airtable & formulas. Was hoping someone could help me find a solution to cleaning up data for a phone field.
I’m pulling data from multiple sources and while most numbers are formatted consistently, there are a few outliers I want t...
I found an easy solution that should work. Wanted to update this thread in case anyone else finds it helpful.
I just removed all non-numeric characters manually as the VALUE() function was giving me an NaN error:
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBS...
