How to use Flash fill in Excel to change text

flash fill

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





Posted in ,

Colin Spooner

Leave a Comment

Your email address will not be published.

one × 5 =

Scroll to Top
Call Now Button