Opening a text file copying a specific set of info for a list off numbers

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

DFlak,

that's correct! you seem to know what I mean!!

although for some reason the code is timing out at this position.

2017-07-04_13-50-44.jpg