Here is some code I have used in the past:

Update Names

Set FullName = RTRIM(FullName)

Update Names

Set FullName = LTRIM(FullName)

Update Names

Set FullName = REPLACE(FullName, ' ', '!')

Where FullName LIKE '% %'

Select FullName...

I would use this little piece of code. First create a DupeId column in your main table. Then dump in your new data. Note: This will only work with exact...