How to pull out numbers from a text string...advanced "text to columns" question

I have a spreadsheet with a column that contains text descriptions of various products. All of the descriptions end with the size of the bottle listed. I need to pull out the bottle size into a separate column. Basically seems like an advanced "text to columns" issue, if I could do the breaks any time there is a number I would be fine, but sadly that isn't an option in Excel and I do not have very good VB skills so a self written macro is out of the question.

Sample data looks like this:

STRAIGHT SHAMPOO 4.5OZ
WINDEX 10.3OZ
DIET CHERRY PEPSI 32OZ

So basically I want the 4.5OZ, 10.3OZ, 32OZ, etc in a different column.

Thanks in advance for any help.

This formula assumes the space before the number is not more than 7 characters away from the end:

=RIGHT(A1,LEN(A1)-FIND(" ",A1,LEN(A1)-7))

EDIT: I think NBVC's formula is a safer bet!

Guys, thanks, that works perfectly... I thought I knew quite a bit about excel but never would have put those functions together like that. Brilliant.