I have long lists of numbers to compare. The entries may have typoes, like a 5 instead of an S. I want to compare the two columns of data, finding similar matches, not exact matches. For instance, number 2C-40019 is in one column, the next has 5C-40019. How can I look for the similarity, i.e. 40019?? and also do this for several rows of data?
Bookmarks