Flash fill in excel

What Is Flash Fill In Excel?

Microsoft Excel's Flash Fill is a clever data entry tool that uses patterns it finds in your data to instantly fill in values in a column. By identifying connections between neighboring data entries and using them to finish a list without the need for formulas or macros, it streamlines repetitive activities. Flash Fill, which was first included in Excel 2013, is especially helpful for rapidly formatting, separating, combining, or extracting data.