How to find text from a column and then paste into other column

[odrisso]

Hi..I want to extract the SNORE from C and paste it to D. Please let me know, what is the formula? Also, I want SNORE will not appear in C after this.

[TABLE="width: 166"]
<tbody>[TR]
[TD]SNORE[/TD]
[/TR]
[TR]
[TD]SNORE[/TD]
[/TR]
[TR]
[TD]SNORE[/TD]
[/TR]
[TR]
[TD]SNORE??[/TD]
[/TR]
[TR]
[TD]SNORE??[/TD]
[/TR]
[TR]
[TD]SNORE??[/TD]
[/TR]
[TR]
[TD]SNORE??[/TD]
[/TR]
[TR]
[TD]SNORE[/TD]
[/TR]
[TR]
[TD]Ex-SNORE?[/TD]
[/TR]
[TR]
[TD]SNORE[/TD]
[/TR]
[TR]
[TD]Ex-SNORE?[/TD]
[/TR]
[TR]
[TD]SNORE[/TD]
[/TR]
[TR]
[TD]Expiratory SNORE?[/TD]
[/TR]
[TR]
[TD]SNORE[/TD]
[/TR]
[TR]
[TD]SNORE[/TD]
[/TR]
[TR]
[TD]SNORE[/TD]
[/TR]
[TR]
[TD]EX-SNORE?[/TD]
[/TR]
[TR]
[TD]SNORE[/TD]
[/TR]
[TR]
[TD]SNORE[/TD]
[/TR]
[TR]
[TD]SNORE[/TD]
[/TR]
[TR]
[TD]SNORE[/TD]
[/TR]
</tbody>[/TABLE]

 

[NeonRedSharpie]

You can't remove SNORE from the cell with a formula. What you can do, it place two formulas in D and E:

Column D:

=SUBSTITUTE(C2,"SNORE","")

Column E:

=IFERROR(IF(FIND("SNORE",C2),"SNORE",""),"")