Hi friends,
I need big help on the following.
I have two columns with texts. Column A has the old text and Column B has the new text. I need to match these two and show in a 3rd column the additional characters (highlighted in red color) in B column compared to A column text. Further in D column to show the additional characters separately.
Would really appreciate if this can be done. Thanks in advance.
Ex.
<tbody>
</tbody>
I need big help on the following.
I have two columns with texts. Column A has the old text and Column B has the new text. I need to match these two and show in a 3rd column the additional characters (highlighted in red color) in B column compared to A column text. Further in D column to show the additional characters separately.
Would really appreciate if this can be done. Thanks in advance.
Ex.
Column A | Column B | Column C | Column D |
Test123$ New. | Test123E Newest | Test123E Newest | Eest |
<tbody>
</tbody>