I am not sure this can be done but wanted to throw it out and see if anyone can help:
The Problem: I have two tables with Vendor Information listed and the vendor is spelled slightly different in both tables. Is there a way to do some match, fix, or anything else to correct the issue. Here is an example of what I am talking about:
Vendor Table 1
Vendor Table 2
In other words the Vendor name in both list is the same but spelled slightly different. Is there any tricks out there.