Use 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.

Use AutoFill in Excel to automatically fill a series of cells. This page contains many easy to follow AutoFill examples.