Skip to content

Instantly share code, notes, and snippets.

@discarn8

discarn8/EXCEL_FORMULA_Convert_to_e164.vba

Last active May 3, 2018 21:28
Show Gist options
  • Save discarn8/6ff5f31cdd58b92ce2e3064c5d79cab4 to your computer and use it in GitHub Desktop.
Save discarn8/6ff5f31cdd58b92ce2e3064c5d79cab4 to your computer and use it in GitHub Desktop.
Download ZIP
EXCEL_FORMULA_Convert_to_e164
Raw
EXCEL_FORMULA_Convert_to_e164.vba
=LEFT(CONCATENATE("+1(",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE((SUBSTITUTE(C2,"(","")),")","")," ",""),"-",""),".",""),"x",";ext=")),6)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment