Extracting Multi-Pack Quantities

I'm having trouble wording this, so I'll just throw it out there...I have a list of items like this:

- Replenishing Lotion Extra Dry, 21-Ounce (Pack of 2)
- Moisturizing Lotion with Shea Butter For Extra Dry Skin
- Anti-Frizz shampoo 3oz. Pump (2 Pack)
- Kids Body Wash, 12 Ounce (4 Pack)
- Jojoba Oil (9 oz)

How do I create a column that will return the quantity in a multi-pack if the item is in fact a multi-pack? Note that some items are labeled "Pack of #" and some are "# Pack" and the format is slightly different for all items.

Any help is greatly appreciated.

Try give explain with a example of your workbook excel file and upload it at the forum