How to use Flash fill in Excel to change text
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
|Tags: Top Tip|