I am mahi solve it

Closed
mahi mahi - Mar 22, 2017 at 09:34 AM
Hello,

=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