How to lookup and remove data from adjacent columns?

[lrussell5]

Hello there, I have been struggling with this and give in! Please help!

What I need to do is remove the data from columns B and C from column A

So that all I am left with is "ROMA CUSHIONS" and "ROMA COVER SETS"

[TABLE="width: 643"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]ROMA CUSHIONS 30X50CM GOLD[/TD]
[TD]GOLD[/TD]
[TD]30X50[/TD]
[/TR]
[TR]
[TD]ROMA COVER SETS S/B GOLD[/TD]
[TD]GOLD[/TD]
[TD]S/B[/TD]
[/TR]
[TR]
[TD]ROMA COVER SETS D/B GOLD[/TD]
[TD]GOLD[/TD]
[TD]D/B[/TD]
[/TR]
[TR]
[TD]ROMA COVER SETS K/S GOLD[/TD]
[TD]GOLD[/TD]
[TD]K/S[/TD]
[/TR]
[TR]
[TD]ROMA COVER SETS SK/S GOLD[/TD]
[TD]GOLD[/TD]
[TD]SK/S[/TD]
[/TR]
[TR]
[TD]ROMA LINED CURTAINS 66X72 GOLD[/TD]
[TD]GOLD[/TD]
[TD]66X72[/TD]
[/TR]
[TR]
[TD]ROMA H/WIFE PILLOWCASE PAIR GOLD[/TD]
[TD]GOLD[/TD]
[TD]H/WIFE[/TD]
[/TR]
</tbody>[/TABLE]

Any help would be very much appreciated!

 

[ChrisM]

Give this a shot, assuming your phrase is in A1, and criteria in B1, C1

=TRIM(REPLACE(REPLACE(A1,FIND(B1,A1,1),LEN(B1),""),FIND(C1,REPLACE(A1,FIND(B1,A1,1),LEN(B1),""),1),LEN(C1),""))

 

[solarmoon]

You may try this, which might sound too rookie and might be lengthy depending on the data size you are working with.

Select all the data in column A. Then press Ctrl+F to open find window. Click on the replace tab and write the word which you want to replace, for instance GOLD. Then click on Replace All which will replace all the GOLD word from your selected range.

The only drawback of the process is that you have to carry the process each time for each of the item you want to remove, for instance once you are done with GOLD, keeping the column selected carry the process for 30X50.