I have created a function that can be called from the column D to extract the auto parts number. I have tested in the other rows and it's working fine.
Result for row3:
1520379, 1520390, 1520395, 1520478, 1520505, DW57120, 10302760, 10303700, 10303701, 10101200, 11101200, 12101200, 6511439, 618120, 4718142, 2UZ19V703, 5U2Z19V703KA, F2UZ19V703, F2UZ19V703FA, 57120, 58120, 6511439, 7511439, 5473, YCC197, 253161, 273136, TEM253161, TEM273136, 2010583, 2010583AM, 57120, 010302NEW, 10302, 142735, 142735C, 142735NC, 142735NEW, 2067, 2067N, 6001279, C388, C388R, 10000502, 10000511, 000079, 001016, 010001, 010394,