You know the drill. Someone has typed lots of data but not kept to the input rules and you need to fix up some stuff.Just look at what they have done everything in lower case AND you only needed the first three letters of the month!
Flash fill to the rescue! Just give it an example of your translation and select flash fill from the data menu with it selected. Sorted. Time for a coffee