Need to split letters from number sequence and group value ranges by number

Hello,

I'm not sure if this can be done, or with what it can be done with. So, here goes. I have two problems. The first, in column F, I need the letter sequence seperated from the number sequence. Second, in column Q I need to group ranges of numbers with a specific indicator. Can that be done at the same time for the same data set? The workbook provided explains in greater detail. Thank you!