Data cleanup of this sort is a classic problem, and the solution depends on how much the data changes each time (i.e. how many new names appear each time you go through the process.

Depending on the data and the business processes creating it, I would be inclined to do one or more of the following
1. Create a separate table listing all the variations of the different names (you can use Advanced Filter to extract unique values from your data) and create a master table that maps them to their 'correct' values using VLOOKUP. A bit of a pain to maintain if the list of variations changes regularly

2. Resign yourself to a bit of manual cleanup - filter the column to show only the #N/As and manually adjust to approved values. You probably end up having to do something like this to keep option 1 above up to date.

3. Preferred option if you're able: modify the place people are putting this data in. Use data validation on their workbook to ensure that they can only select from an 'approved' list of names. You could offer to set this up for them, and they might be open to it if you explain how much of your time they are wasting!