Extracting Data

[sierracommerceco]

Need a good formula to extract the last number before the ")" from the following cell info: Note that each line is a different cell.

So for example, on line 1, I need to extract the 12 and put it into its own cell.

Lentil Chip Cr Pepp Bake 1 OZ (Pack of 12)
Lentil Chip Rosemary Bak 1 OZ (Pack of 12)
Lentil Chip Sea Salt Bak 1 OZ (Pack of 12)
Sprd Og2 7Nut&Sd Btr with P 16 OZ (Pack of 6)
Matzah Thin Whole White Pass 10.5 OZ (Pack of 12)
Matza Thin Plain Pass 10.5 OZ (Pack of 12)
Cocktail Stirrers 16 OZ (Pack of 6)
Sustain Bath Shower Mitt 1 Ct (Pack of 6)

[sktneer]

Try this......

Please Login or Register  to view this content.