discarn8/EXCEL_FORMULA_Convert_to_e164.vba

Last active May 3, 2018 21:28

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/discarn8/6ff5f31cdd58b92ce2e3064c5d79cab4.js"></script>
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