Formula to take a rating (text - multiple choice field) and pull the numeric digit out into a numeric field

I have a text field - multiple choice rating field [Rating Category] with the list of choices as shown in the formula below. I need a second field, numeric, so I can total & average the ratings.  I se...