Searching for a numbers from right within a text string

Hi, I have a list of notes that contain text and numbers within a cell. I need a formula if possible that searches from the right of the cell and then returns the all the numbers.

e.g.

1.Inter 2. Juventus 3. R0ma 4.Cagliari formula result 4
3. Politics;5 National, 7. Biology formula result 7
19geographic formula result 19

attachment
data.xls

The Result is extract a numbers within text cell from right.
I can not use text to columns as they data is not consistant.

Also worth noting is that the notes vary from 1 digit to 9 digits long.

Any help would be great

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi,

Can't do better than this, I'm afraid:

=LOOKUP(100^100,--MID(A1,LOOKUP(2,1/((1-ISNUMBER(--MID(A1,ROW($1:$1000),1)))*(ISNUMBER(--MID(A1,ROW($2:$1001),1)))),ROW($2:$1001)),ROW($1:$1000)))

Regards

Try this formula for data in A2

=LOOKUP(10^9,RIGHT(LEFT(A2,MAX(IFERROR(FIND({1,2,3,4,5,6,7,8,9,0},A2),0))),{1,2,3,4,5,6,7,8,9})+0)

If A2 has no digits the result will be #N/A