Often known as the universal data munging tool, Excel is trying out new options for processing messy text as well as entering it more quickly and accurately in the first place.

Prevent duplicates before they happen by combining a simple function with data validation.

Have you played with the "Text to Columns" function on the Data menu/tab yet? It's similar but not quite identical to the File Open text importer.