How to extract the right most numbers from a text string?

[technomarketing]

Hello,
I need to extract numbers from a text string. The numbers appear to the right of the string. There are actually two numbers there. One is the count and the other is the percent. I definitely appreciate any help or advice. The data is formatted like this: [TABLE="width: 800"]
<tbody>[TR]
[TD="width: 800"]E20 No Place Like Home 140 12.79%

[/TD]
[/TR]
</tbody>[/TABLE]

 

[technomarketing]

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255)) returned the 12.79% I was looking for. I must have entered it in incorrectly. I will re-try Rick's formula too.

 

[technomarketing]

I was able to get Rick's to work too. Thank you both.

 

[Jonmo1]

You're welcome.

 

[Rick Rothstein]

I must have entered it in incorrectly.

For future reference, don't try to enter the formulas yourself... simply copy/paste them into the Formula Bar... it is hard to get it wrong that way.