Get all values between 2 strings

If the table provided is TableK and these values 1B45877, 8G74584 are in a table (TableP) - which is not connected with a relationship -

and are then pulled in to a table visual, you can create a measure :

MeasureA = VAR _PVal = MIN(TableP[Column1])
RETURN
CALCULATE(MIN(TableK[VALUE]), TableK[FROM] <= _PVal && TableK[TO] >= _PVal) 

 This will require testing because it relies on < , > working for the alphabetical comparison so I suggest testing edge cases.  In my head it feels OK but I may be wrong.