In the attached workbook i need to take out the % numbers from the text to populate the cells.

the Pay % cell is the % before the / and the receive % is after the /.

I've hardcoded what the cells should be, any ideas how i can use a formula for this?