I don't know if anyone will find this useful but I recently had to clean some data of misspellings before I could use it with VLOOKUP. I found some VBA that highlighted the misspellings but nothing to extract the actual words. Eventually with some prompts I wrote the following:-
Sub...