Row | Collumn1 | newcollumn |
1 | Thoughts MN | MN |
2 | 120Agents target | target|
3 | Eldoradonet target | target |
4 | eBorkin target | target |
5 | Flightair NP | NP |
6 | Getcardshere target | target |
7 | NoMadic | |
8 | timetoeat target CONVER | target CONVER |
9 | 4usa default time | default time |


Using the text in collumn1 i.e. "Thoughts MN" I need to create a new
collumn that would insert values based upon specific words in collumn1.
The above tries to show what I need. The function would need to insert
the values into newcollumn if it matches a word in collumn1.

the words are MN , target, NP, target CONVER, default time and a blank
space

Thanks for the help


--
exceluser2
------------------------------------------------------------------------
exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338
View this thread: http://www.excelforum.com/showthread...hreadid=517917