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.
Share this post
Twitter
Facebook
Reddit
LinkedIn
StumbleUpon
Pinterest
Email