and I'm seeing another potential issue... after removing the quotes from the lookup table in the 2 formulas in col O, then re-ran it, ---- those 2 formulas need to be relative to the cell at the left it's looking at.... (COL A)

So, if it gets down to ROW 10, those filesnames are longer in LEN and need to use a formula that would read:
=MID(A10,14,5)

Currently, the formula is col O is looking to A2
In other words,
IF A2 is 21 chars long use the formula in O2
If A2 is 22 chars long use the form in O3

BUT as it pastes down within col K it needs to be relative
A2
A3
A4
A5
and when it gets to row 10 it will know to adjust to A10