Capture2.JPG

We have imported some data which has been corrupted therefore the spelling is wrong. We have access to the old data but are struggling to match it up with ID number due to incorrect spelling.

We need to match up the correct contact name (Column C) to Column B, either appearing in Column D OR replacing the corrupted name (incorrect spelling) in Column B.

Thanks in advance!