karl taylor

1 minute read

A few weeks ago, we were working with a client that had been relying on an integration between Zapier and Facebook to take data out of the lead card product and integrate it with a CRM. This is pretty common practice, and nowadays there are better ways to do this. One common problem when cleaning this data, however, is removing the non-numerical characters from a column of phone numbers.

Here’s an easy way to fix this in Google sheets.

[embed]https://youtu.be/Zw0Ne1dWCSg[/embed]

comments powered by Disqus