need vba code to validate the names from names of group in column a:a

Dear experts

i have bunch of data more than 1lk rows items i getting tired to solve this manually
billing names which is not complete i want replace names through key matches of name group of M:M

acutal name is JEOSPH but it entered as jeo i want replace jeo as JEOSPH.

Find the attachment
need vba code to validate the name of group in column a:a