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.