Return a specific string in text without using text functions.

For automation purposes, I am trying to extract an identifying number from a cell that has multiple, varying characters on either side (hence why no left or right, unless you have a fancy way to use them). Workbook attached