Hi All,

I have a situation where I need to fill Column B with Text Depending on what
Text is in Column A eg

Column A Column B

1 GREAPPLES GREEN Products
2 PEARSGREEN GREEN Products
3 GreenGarbage GREEN Products

In other words I would be using GRE as the condition in Col A for a product
to classed as GREEN Products
I would be grateful if someone can point me in the right direction.
Thank you

Edwin