inserting value if another cell contains a specific word

E

exceluser2

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
 
C

CLR

Assuming your data is in column A and there are no leading spaces in the
cells, and there is a trailing space on cells that do not have at least two
spaced words...put this in B1 and copy down..........

=MID(A1,FIND(" ",A1,1)+1,99)

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

Use this instead.........

=IF(ISERR(MID(B2,FIND(" ",B2,1)+1,99)),"",MID(B2,FIND(" ",B2,1)+1,99))

Vaya con Dios,
Chuck, CABGx3
 
Top