Skip to content

Instantly share code, notes, and snippets.

@alexanderjsingleton

alexanderjsingleton/phone-number-regex.gsheet

Last active May 28, 2016 01:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alexanderjsingleton/d708a76bf3cb3062d3079419bb0347ac to your computer and use it in GitHub Desktop.
Save alexanderjsingleton/d708a76bf3cb3062d3079419bb0347ac to your computer and use it in GitHub Desktop.
Download ZIP
Assuming column C contains different phone-number formats, insert the following regex in adjacent column D2 for uniform formatting.
Raw
phone-number-regex.gsheet
=ArrayFormula(replace(replace(regexreplace(C2:C&"","[-/. ()]",""),4,0,"-"),8,0,"-"))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment