Flash Fill in Excel 365

picture of excel logo

What does Flash Fill do? Flash Fill adds a level of intelligence in recognising a pattern and completing it based upon nearby data. In some instances, it makes functions like concatenating, left/insert and extract redundant, in a flash!