How can I pull out specific text from a cell, for example if I have the following
Budweiser 12pk Bottle 12oz
Yeungling 6pk Can 12oz
Heineken Keg 13.2gal
Stella 12pk Bottle 18oz
in the column after this I want to be able to extract whether it is a can, bottle or keg.