Skip to content

Instantly share code, notes, and snippets.

@hisabimbola

hisabimbola/script

Created September 2, 2016 06:12
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save hisabimbola/3ce35e4fb6530c0ea4eff44035ceb5ae to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save hisabimbola/3ce35e4fb6530c0ea4eff44035ceb5ae to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Abimbola Idowu created this gist Sep 2, 2016.
    1 change: 1 addition & 0 deletions script
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    =IF(LEN(REGEXREPLACE(IF(LEN(SUBSTITUTE(AL1," ","")) = 11,SUBSTITUTE(AL1," ",""),""),"^0","+234")) = 14,REGEXREPLACE(IF(LEN(SUBSTITUTE(AL1," ","")) = 11,SUBSTITUTE(AL1," ",""),""),"^0","+234"),AL1)