PDA

View Full Version : [SOLVED] Extract numbers starting with 07



Sophia
10-18-2019, 10:16 AM
Hi Guys,

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

Thanks

Leith Ross
10-18-2019, 10:58 AM
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
10-18-2019, 12:49 PM
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.