I have a similar problem however I have data that has 2 spaces and I need the numeral at the end. With the formula above I get the word and numeral.

ie
cell = word word: number

need result
number

I had tried RIGHT(B143,FIND(" ",B143)-9) however the number is not always the same number of digits and it sometimes gives a result including part of the text before it, or not all of the number.