I have a spreadsheet that has several columns & rows. One column contains
the type of program the customer is on (ie., gold, silver, bronze) although
it is not spelled out that simply - it is Progam 1 Gold 09, etc. I am
trying to create a formula that will only return the words gold, silver or
bronze. I have tried using Mid & Find, but can only make that work for one
of the programs. Any help would be appreciated. thanks.