Split data within cell in Excel

Job ID: 33946206

Budget: $10 – $30 USD

Hi there:

I am looking for the EXCEL formula that will pull "Disb#of" from the below:

TESTA-0422_Disb1of2 (need to pull Disb1of)
ABCD-0422_Disb1of100 (need to pull Disb1of)
FGH-0622_Disb2of4 (need to pull Disb2of)
DFG-0722_Disb20of40 (need to pull Disb20of)
Related categories: Visual Basic Data Processing Data Entry Excel