Compare 2 text cells and show difference in the third cell
If cell A1 = abcd, cell B1 = abcdefg, then what formula to use in order to get the text difference efg?
Solution 1:
By using the following formula, you can achieve just that:
=SUBSTITUTE(B1,A1,"")
Reference: SUBSTITUTE