This works for the *one* example you gave.

=IF(ISNUMBER(SEARCH("Gre",A1)),"Green Products","")

Leaving Column B blank if it doesn't find "Gre",
BUT ... don't you have *other* text to look for?

A different formula would be called for if you have a large datalist to look
for.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Edwin Mashiringwani" wrote in message
...
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