Once you type the first and last name in the first cell, click in the next cell down. Then hold down the Ctrl key and press E. Flash Fill will populate your column based on the pattern it detects. In ...