The more sophisticated developers will laugh at this, but hey, it works.
You can upload all your data into one table and create a formula field for each errant character to be removed.
The Remove apostrophe Text formula is:
Left([New Supplier-Contact Name],"'")&Right([New Supplier-Contact Name],"'")
Notice that the formula above works the original hard data.
Then, the Remove period Text formula is:
Left([remove-apostrophe],".")&Right([remove-apostrophe],".")
Notice that the remove period formula works the remove apostrophe formula. After you get the results you want, you can remove dups with Excel.
Hope this helps.
Chris
