Skip to content

Instantly share code, notes, and snippets.

@discarn8

discarn8/EXCEL_FORMULA_Convert_to_e164_non-hypenated.vba

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