Home/ Questions/Q 8333
Next
Answered
computing
  • 11
Asked: 2021-11-28T10:05:48+00:00 In:

Solved How To Separate Mobiles Phone Numbers And Landlines Numbers

  • 11

HI
i have more than 10,000 customer uk phone numbers in one excel sheet column A. spent no. of hours to create database from bills and phone lists. i need only mobile phone numbers.

Example
numbers starting with: 07 are mobile numbers and rest are landlines. both are 11 digits long. how do i filter only mobile phone numbers.

COLUMN A

07965665464
07856675899
02086765654
07987655678
07654345676
02076786546
01124765758
01789876678
07511453765

Please help.
i am trying to use option FILTER ,
when when i click there it says FILTER NUMBERS and then i clicked CUSTOM FILTER,,, and then BEGIN WITH 07,,, still it not showing anything.

i am using WINDOWS MICROSOFT OFFICE 2010

message edited by sulmanmushtaq

Share

    1 Answer

    1. Best Answer
      Actually, if they all start with 0, then Option 1 should be enough since as far as Excel is concerned, the leading 0 does not really exist. Excel should see each number as a 10 digit number “internally” and therefore the LEFT function will see the second displayed digit as the first.

      Give it a try.

      Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

      • 0