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.

SNORE

SNORE

SNORE

SNORE??

SNORE??

SNORE??

SNORE??

SNORE

Ex-SNORE?

SNORE

Ex-SNORE?

SNORE

Expiratory SNORE?

SNORE

SNORE

SNORE

EX-SNORE?

SNORE

SNORE

SNORE

SNORE

<tbody>
</tbody>

 

[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",""),"")