I have around 800,000 mobile number database. It's in Microsoft Excel.
Every mobile number is on new line.
Every mobile number has country code, specifically, starting with 91.
Some mobile numbers are wrong; they just start with 12, or 59, etc. I want to discard such numbers which do not start with 91.
Is there any way/formula by which I can distinguish/remove the numbers which do not start with 91?
Excel formula to separate numbers
- z3r0aCc3Ss
- Fame ! Where are the chicks?!
- Posts: 700
- Joined: 23 Jun 2009, 16:00
- 14
- Contact:
Excel formula to separate numbers
Beta tester for major RATs, all kinds of stealers and keyloggers.
Learning NMAP
Learning NMAP
- bad_brain
- Site Owner
- Posts: 11636
- Joined: 06 Apr 2005, 16:00
- 19
- Location: In your eye floaters.
- Contact:
Re: Excel formula to separate numbers
have a look here:
http://en.kioskea.net/faq/6261-excel-a- ... fic-values" onclick="window.open(this.href);return false;
http://en.kioskea.net/faq/6261-excel-a- ... fic-values" onclick="window.open(this.href);return false;
-
- cyber messiah
- Posts: 1201
- Joined: 30 Apr 2006, 16:00
- 17
- Location: 127.0.0.1
Re: Excel formula to separate numbers
or get a parsing library in perl or your favourite scripting language and use Regex