=IF(ISERROR(SEARCH("*keyword*",A1,1)),"","keyword") it is only for one cell
it perfectly ok for multiple cell its not ok
this formula how can i use for multiple colum example is given below A1 to A12
how can i find the different words and paste in next cell
1 PHRASES ASSIGNED TO KEYWORD ASSIGNED TO
2 THE OCEAN IS BLUE BLACK ARNOLD
3 I LIKE HIS WHITE SHIRT BLUE CHRIS
4 BLUE IS MY FAVE COLOR BROWN FERNANDO
5 THE OCEAN IS RED LAVENDER GENER
6 I LIKE HIS RED SHIRT MAGENTA JEFF
7 RED IS MY FAVE COLOR ORANGE JOHN
8 THE OCEAN IS YELLOW PINK NAP
9 I LIKE HIS YELLOW SHIRT RED PERRY
10 YELLOW IS MY FAVE COLOR WHITE RAMIL
11 THE OCEAN IS PINK YELLOW MARL
12 I LIKE HIS PINK SHIRT
i want to find words in each cell if blue is not there it need to search other ex:- blue... son if it find it should paste in next cell