Consulting

Results 1 to 3 of 3

Thread: Extract numbers starting with 07

  1. #1
    VBAX Regular
    Joined
    Oct 2019
    Posts
    14
    Location

    Extract numbers starting with 07

    Hi Guys,

    Please check excel sheet attached and advice, is any way to excrat only File #: 07* or not?

    Thanks
    Attached Files Attached Files

  2. #2
    VBAX Expert Leith Ross's Avatar
    Joined
    Oct 2012
    Location
    San Francisco, California
    Posts
    518
    Location
    Hello Sophia,

    This assumes all of the file numbers are 6 digits. Copy this into cell B1 and drag the formula down as far as you need.

    =IF(MID($A3,SEARCH(":",$A3,1)+13, 2)="07",MID($A3,SEARCH(":",$A3,1)+13, 6),"")
    Sincerely,
    Leith Ross

  3. #3
    VBAX Regular
    Joined
    Oct 2019
    Posts
    14
    Location
    Hi Leith,


    Thank you for your help formula is working. Before I marked it as solved could you please think how you can advance this formula that if it is 0 or empty (no date starting with 07) put value from previous cell and continue this proses till non empty cell.
    see attached file.
    Attached Files Attached Files
    Last edited by Sophia; 10-18-2019 at 12:58 PM. Reason: to add attachment

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •