![flash fill in excel flash fill in excel](https://cdn.educba.com/academy/wp-content/uploads/2019/01/flash-fill-5.png)
We didn't have to use a formula and we surely did not type all of these one at a time. Steps to implement Flash Fill in Excel Insert three columns in your Excel worksheet. Not to be confused with Autofill, which detects series, like days of the week or sequence of numbers, Flash Fill detects patterns. Rolling Meadows is right, Cambridge is right, everything is right. Capital M-I-A-M-I, and then let's highlight this whole range, go to data, flash fill.
![flash fill in excel flash fill in excel](https://trumpexcel.com/wp-content/uploads/2017/03/Using-Flash-fill-in-Excel-example-3-result.png)
So let's escape out and train the flash fill. This is flash fill asking, is this what you want? So look, it's not fixing the cases.
![flash fill in excel flash fill in excel](https://www.kodyaz.com/images/ms-excel-2013/microsoft-excel-2013-flash-fill-feature.png)
And then watch, type the B for Baltimore. We're going to clean this up, flash fill, Jack. Rolling Meadows, we've got an upper case and a lower case. Challenge is we have is New York is two words. We've got, in this example, the cities and the state abbreviation. This is new in Excel just within the past few years, and it deals with a situation where when we get data that we can't use, how do we clean it up? In this case, flash fill is magical. (upbeat music) - So I got a beautiful thing to whoop on you right now. Flash Fill is an amazing tool that analyzes the information you are feeding into a cell and automatically fills data when it identifies a pattern.