Flash Fill is a feature in Excel that automatically enters values in a column when a pattern is recognized. It can save a lot of time when manually entering a long list of data, like consecutive values or dates.
Click the cell to the right of the data you want to work with.
Type the first value you want to extract in the new column and press Enter.
Begin typing the second value below the first.
When you start typing in the second value, Excel recognizes the pattern and predicts the values for the rest of the column.
If the pattern isn’t recognized when the second cell is populated, complete the data for the second cell and move to the third. The pattern should be recognized when you begin entering data in the third consecutive cell.
Press Enter to accept the suggested Flash Fill values.
Excel populates the rest of the column following the same pattern of data.