I have this kind of product id in column D:
1942-PS-M-01
1942-PS-M-233
1942-P-M-25
1942-P-L-200
I want to set the value in column E Using the last 2/3 number in the product id value.
I tried to use formula such =MID([Product_ID],11,3) and =MID([Sample_ID],10,3), but none of this id efficient.
Is there any way to do so?