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.