Moving specific Text from a cell

[David Rod]

Hello! I am trying to move two specefic words from a string of text from one cell to another. each cell will have either word, within a string of text, but will not contain both words. I started with this formula: Example: [TABLE="width: 165"]
<tbody>[TR]
[TD]PRT REL TECO
[TABLE="width: 165"]
<tbody>[TR]
[TD]CLSD REL [/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]


=RIGHT(E2,LEN(E2)-FIND("TECO",E2,1)+1)

I was able to get "TECO" in the cell, but i know want to add the word "CLSD" to the formula so it looks for both. If the cell contains TECO OR CLSD, add to the other cell.

I tried to add the "OR" formula but that logic didnt seem to work. Anyother ideas??

Thanks!

 

[NeonRedSharpie]

=IFERROR(IF(FIND("TECO",A3),"TECO","Not Found"),IFERROR(IF(FIND("CLSD",A3),"CLSD","Not Found"),"Not Found"))

This is probably a little redundant, but it should work.

 

[David Rod]

Thanks! it worked!

 

[István Hirsch]

Give this formula a try:

=IF(COUNTIF(A1,"*TECO*"),"TECO","CLSD")