Flash Fill, introduced to Microsoft Excel in 2013, was a time-saving game changer. It recognizes patterns in your data, and uses those patterns to suggest ways to automatically fill in the rest of ...

Figure C Let’s use Flash Fill to parse entries across three columns. The first step is to create the pattern by entering the first three values manually in row 2.

See this short tutorial video for Windows users or this tutorial video for Mac users for a step-by-step overview of how to use Excel’s Flash Fill feature to automatically fill in data based on ...

Source data won't always come in the form you need in Excel. When that happens, consider using Flash Fill to save time and aggravation.