I wrote a huge formula using the left(), mid() and possibly right() functions to extract item codes. It was an experimental file and I have lost it!

I have a table with species names... I would like to create an item code that consists of the first two letters of the GENUS, first to letters of the SPECIES (text for this is in ONE cell) and the ## from size. See example below. Bold is the formula I want to create to extract the text.

Genus species, Size, CODE
Bambusa multiplex, 15g, BAMU15
Bambusa oldhamii, 05g, BAOH05

Can anyone help me come up with a formula to extract this information?

Thanks,

P.S. Notice how the code is in all CAPS...is there a way to integrate that into the formula? I believe it is the UPPER() formula...

__________________
RichAndClever.com - Portfolio
Columbus, Ohio Small Business Marketing