How To Use Flash Fill in Excel2020-1-31AutoFill RangeUse flash fill in Excel 2013 or later to automatically extract or to automatically combine data. Flash Fill in Excel only works when it recognizes a pattern.
How to Use AutoFill in Excel2020-1-31Range AutoFillUse AutoFill in Excel to automatically fill a series of cells. This page contains many easy to follow AutoFill examples.