Flash Fill is similar to the AutoComplete feature, but it is new to Excel 2013. It looks for patterns in your data and shows a suggestion. As soon as it detects what you are attempting to do, it shows a recommended pattern.
In the following example, full names have been entered in Column A. In Column B, this is what happens when you begin entering just first names, pressing Enter after each: