Mobile Number Filter ( Formula for begins with in data)

  • Hi Team,

    I am new for this site :- so might be this is already been posted my applogies if i am posting it again in different header.

    Help Required:-

    I have data in which i have Mobile number / Address / Name of Party in different cells.

    I am looking for extract mobile number from it. hope some of you may able to help me in this regards.

    *** I am attaching data file which contain two sheets with different format which will give you better understanding of my requirement.

    ozgrid.com/forum/core/index.php?attachment/34362/

    Thanking you in advance.

    Files

    • Data.zip

      (31.58 kB, downloaded 64 times, last: )
  • Re: Mobile Number Filter ( Formula for begins with in data)


    How do you want to extract Mobile phone, where to put the information.
    Do you want to only highlight the cell with Mob contain.
    Note: Your data is not presented as EXCEL would like to see it --> data in column, one column per data, one header per column, no merged cells.
    Like that, you will profite of the tools Excel can provide you: Extract Mobile for example

    Triumph without peril brings no glory: Just try

  • Re: Mobile Number Filter ( Formula for begins with in data)


    I think the easiest way to do this is with Advanced Filter.

    Add a header row to either Worksheet. Then:
    A1: Data
    I1: Data
    I2: Mob*:

    Then Data > Filter > Advanced Filter

    Fill in the dialog to select all your data columns, the criteria (in I1:I2) select Copy to another location and select where you want your list of Mobile numbers to appear (must be on the same sheet). Then OK.