|If you are starting with this...|
1 Defects Notice - DF_0079
2 DF_0022- MIP00020- Kedron BR 701
...then this formula should extract the DF number:
If you put this in Sheet2!A1 - perhaps a new Column A if you already have data in Column A - and drag it down, then you should be able to VLOOKUP on Sheet 1 to return the value from any other column in Sheet 2.
Note: I used the string "DF_" to hopefully ensure that no other string like "DF" or an underscore causes the FIND function to return the wrong start_num argument for the MID function.
MP_P00020 - DF_0022
Defects Notice DF443 - DF_0079
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.