Hi Guys,
Please check excel sheet attached and advice, is any way to excrat only File #: 07* or not?
Thanks
Hi Guys,
Please check excel sheet attached and advice, is any way to excrat only File #: 07* or not?
Thanks
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
"1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG"
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.
Last edited by Sophia; 10-18-2019 at 12:58 PM. Reason: to add attachment