Split data within cell in Excel
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)
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)