Hi all,

I have some string in a column e.g:-

The pen is blue.
Red eyes of devil.
Sky is blue.
White is my favorite color.


and in other column i have some color listed e.g:-

Red
Green
Blue
Black
Brown
White
Pink

now i want the color in the string based on the color listed in other column e.g:-

The pen is blue. blue
Red eyes of devil. Red
Sky is blue. Blue
White is my favorite color. White


only by using formula.

thanks in advance