How to use the Flash Fill feature in MS Excel
When working on a spreadsheet in MS Excel with a lot of data, things can get overwhelming, but some features in the application can make your work go more smoothly. Flash Fill is one of those helpful features in Microsoft's spreadsheet app. What is the Flash Fill feature?Flash Fill fills your data for you automatically when it detects a pattern. Flash Fill can be used, for instance, to split up first and last names from a single column or to combine first and last names from two different columns. It's beneficial to use…