Trick 018 Compare the difference in characters between two paragraphs

 In the previous post, I showed you how to compare and find the difference between two data tables with power query. The problem today is that we compare two passages with each other. 

  It's no big deal to manually compare two cells, but it's nearly impossible to spot the difference between hundreds and thousands of text strings.

   And now let's see this example with power query. From there we spread the same data between the two tables.