Hi Dflak,

just a question regarding this macro;

it looks at column A the part number

and applies the formula to get the part number as follows

2017-07-03_12-15-11.jpg
2017-07-03_12-15-29.jpg
id there any way you can update the formula to show the part number in the format 1048758_301 and also in 18758301 (2nd and third character removed)

2017-07-03_12-15-40.jpg

some times the part numbers are saved in the two different formats in the directory..

Thanks