Find The Difference Between 2 Strings Of Text. Using DIFFERENCE function with similar SOUNDEX values. Function WORDDIF rngA As Range rngB As Range As String Dim WordsA As Variant WordsB As Variant Dim ndxA As Long ndxB As Long strTemp As String WordsA Split rngAText.
Select a blank cell C2 enter formula EXACT A2 B2 into the Formula Bar and then press the Enter key. For ndxB LBound WordsB To UBound WordsB For ndxA LBound WordsA To UBound WordsA. This awesome tool not only highlights the words within the cluster of lines that entail a difference.
DifferenceQuery names1Except names2.
You may want to modify the excellent ideas presented to do the comparisons both ways. Old 1235 New 1234 Meaning that the code will correctly find that 4 was added. Keep the console window open in debug mode. The two texts will be shown on the screen side by side along with the differences highlighted.
