inserting value if another cell contains a specific word
 

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

inserting value if another cell contains a specific word
 

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



"exceluser2" wrote:


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

inserting value if another cell contains a specific word
 

great! For the cell "NoMadic" which has no value after it I get the
#VALUE! error. How can I change this to just a blank cell?


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

inserting value if another cell contains a specific word
 

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

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

Vaya con Dios,
Chuck, CABGx3




"exceluser2" wrote:


great! For the cell "NoMadic" which has no value after it I get the
#VALUE! error. How can I change this to just a blank cell?


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