Excel formula to separate numbers

Stuff that don´t fit in the other categories.
Post Reply
User avatar
z3r0aCc3Ss
Fame ! Where are the chicks?!
Fame ! Where are the chicks?!
Posts: 700
Joined: 23 Jun 2009, 16:00
14
Contact:

Excel formula to separate numbers

Post by z3r0aCc3Ss »

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?
Beta tester for major RATs, all kinds of stealers and keyloggers.
Learning NMAP

User avatar
bad_brain
Site Owner
Site Owner
Posts: 11636
Joined: 06 Apr 2005, 16:00
19
Location: In your eye floaters.
Contact:

Re: Excel formula to separate numbers

Post by bad_brain »

have a look here:
http://en.kioskea.net/faq/6261-excel-a- ... fic-values" onclick="window.open(this.href);return false;

:wink:
Image

pseudo_opcode
cyber messiah
cyber messiah
Posts: 1201
Joined: 30 Apr 2006, 16:00
17
Location: 127.0.0.1

Re: Excel formula to separate numbers

Post by pseudo_opcode »

or get a parsing library in perl or your favourite scripting language and use Regex

Post Reply