I have a table of possible names, Column A with the accepted spelling, and columns B through ~ G are possible mis-spellings. Not all columns are full, i.e. some names may only have 3 known mis-spellings, while some may have a full 6. Next, I have an Access Database which is horribly designed, names are all in one column, and many names have 4 or 5 parts (i.e. John Michael Ray Duncan Clarke), which hopefully through programming I can convert to (Jon Mikael Rae Dunkan Clarke) (as an example).
I think to sum my goal, it would be to use the excel spreadsheet as a custom dictionary, doing a somewhat ad-hoc find and replace to correct the names that are spelled unacceptably. Can anyone offer some suggestions?