VBA code for Text Diff between two columns?

[Akila868]

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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A
[/TD]
[TD]Column B
[/TD]
[TD]Column C
[/TD]
[TD]Column D
[/TD]
[/TR]
[TR]
[TD]Test123$ New.
[/TD]
[TD]Test123E Newest
[/TD]
[TD]Test123E Newest
[/TD]
[TD]Eest
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Akila868]

Here's the result I got, it isn't what you expected? [TABLE="width: 426"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC$123.[/TD]
[TD]ABCU123.[/TD]
[TD]ABCU123.[/TD]
[TD]U[/TD]
[/TR]
[TR]
[TD]DDD;889@[/TD]
[TD]DDDL889P[/TD]
[TD]DDDL889P[/TD]
[TD]LP[/TD]
[/TR]
[TR]
[TD]Dustin[/TD]
[TD]Duxtinx[/TD]
[TD]Duxtinx[/TD]
[TD]xx[/TD]
[/TR]
</tbody>[/TABLE]

Yes. But this is what I am getting. I used in some other data I had.

[TABLE="width: 638"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[/TR]
[TR]
[TD]Testing Medical Institute Ltd.[/TD]
[TD]Testing Medical Institute Limited[/TD]
[TD]Testing Medical Institute Limited
[/TD]
[TD]imited
[/TD]
[/TR]
[TR]
[TD]Lester Mango Exports LLc[/TD]
[TD]Lester Mang Exports, LLc[/TD]
[TD]Lester Mang Exports, LLc
[/TD]
[TD] Exports,
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Akuini]

Your new example, that's a different story, sorry I don't know how amend the code to deal with such case.
Hope someone else would step in.

 

[Akila868]

Your new example, that's a different story, sorry I don't know how amend the code to deal with such case.
Hope someone else would step in.

Oh sorry. No problem. Thank you for the help.

 

[pmich]

The reply given by Akuini is what you expected as per your previous post.
But I understand that you want something else.
Please give some explanations.

You have mentioned :
'Just need to compare character by character from left to right in the same order and display difference in characters.'

The original text is displayed in Column C.
The differences in characters are shown in color in Column C.
The additions are shown in Column D.
Do you want just to display in Column C the differences in characters shown in color omiting the original Text?

You have mentioned :
'It should instead highlight the characters that came in new/ removed/ replaced by comparing the two words in two columns.'

The characters that came in new are shown in red along with the original text in Column C.
What else do you want?

Do you want just to display the characters that are removed?
If so, in which column?
How, in Red or in Black?
With the Original text or without?

Do you want just to display the characters that are replaced?
If so, in which column?
How, in Red or in Black?

It will be good if you give an example of the original text in Column A, the modified text in Column B, along with what all you want to be displayed in what columns and in what colors.