Excel: Remove only true cell content if its in a other cell

Posted on

QUESTION :

Cell A1: House of Cards
Cell B1: of Cards
Cell C1: EXPECTED RESULT House

Cell A2: Looking forward to hear
Cell B2: to hear
Cell C2: EXPECTED RESULT Looking forward

So, C1 should basically be the result of A1 minus exact content of B1.
and so on.

Any idea how to achieve this?

ANSWER :

=SUBSTITUTE(A1,A2,"")

Takes the text in A1 and replaces occurrences of the text in A2 with the empty string. So “House of Cards” becomes “House” because “of cards” has been replaced with nothing.

Leave a Reply

Your email address will not be published. Required fields are marked *