Extract numbers starting with 07

[Sophia]

Hi Guys,

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

Thanks

[Leith Ross]

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),"")

[Sophia]

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.