Home >  Blog >  How to use Flash fill in Excel to change text

How to use Flash fill in Excel to change text

Posted on 25 June 2018
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 

 

 

 

 

 

 

 

Tags: Top Tip