Remove a string based on other column value

[andranos]

Hey guys,

Need some help with deleting a value using other cell value as a reference
For example:

Column A, Column B, Result
Random1, I Love Random1 Apple, I Love Apple
Apple, Apple is Sweet, is Sweet

More or less like that
Thanks in advance guys

 

[jim may]

Try:

Excel 2012
	A	B	C
1	Column A	Column B	Result
2	Random1	I Love Random1 Apple	I Love Apple
3	Apple	Apple is Sweet	is Sweet
Sheet1

Cell Formulas
Range	Formula
C2	=SUBSTITUTE(B2,A2,"")

 

[Rick Rothstein]

Try:

Excel 2012

	A	B	C
1	Column A	Column B	Result
2	Random1	I Love Random1 Apple	I Love Apple
3	Apple	Apple is Sweet	is Sweet

<colgroup><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C2 =SUBSTITUTE(B2,A2,"") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Maybe wrapping a TRIM function around that would be useful...

=TRIM(SUBSTITUTE(B2,A2,""))

 

[andranos]

Try:

Excel 2012

	A	B	C
1	Column A	Column B	Result
2	Random1	I Love Random1 Apple	I Love Apple
3	Apple	Apple is Sweet	is Sweet

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C2 =SUBSTITUTE(B2,A2,"") <tbody> </tbody>

<tbody>
</tbody>

Works like a charm
There's another problem though
Here's an example

Excel 2012

	A	B	C
1	Column A	Column B	Result
2	Love	I Love Apple Love	I Love Apple
3	Apple	Apple is Sweet Apple	Apple is Sweet

<tbody>
</tbody>

<table cellpadding="2.5px" rules="all" verdana,="" arial,="" tahoma,="" calibri,="" geneva,="" sans-serif;="" border:="" 1px="" solid="" rgb(187,="" 187,="" 187);="" border-collapse:="" collapse;"="" style="width: " width=""><colgroup><col><col><col><col></colgroup><thead></thead><tbody></tbody></table>

I need to remove the duplicated keyword based on column A value and the latest one will be deleted
And the condition only applies if the keyword from column A is duplicate in column B. If it's not, leave it as it is
Is that possible?

Cheers

 

[jim may]

Try:

Note addition of the "2" as an additional argument at the end. This instructs excel to "START" the search AFTER finding number 1 (the first instance). Hope that helps. Jim

Excel 2012
	A	B	C
1	Column A	Column B	Result
2	Love	I Love Apple Love	I Love Apple
3	Apple	Apple is Sweet Apple	Apple is Sweet
4	Sour	Apple is Sweet Apple	Apple is Sweet Apple
Sheet1

Cell Formulas
Range	Formula
C2	=SUBSTITUTE(B2,A2,"",2)