Top Ten New Features in Excel 2013
This nifty new feature is literally a mind reader when it comes to dealing with multipart cell entries in a single column of the worksheet that contains discrete elements you could better use if they were entered all by themselves in separate columns of the sheet.
To separate discrete elements from longer entries in the column, all you have to do is manually enter the first element in the longer entry you want extracted into a cell in the same row in an empty column to the right terminated by pressing the down arrow.
Then, the moment you type the first letter of the corresponding element in the second long entry in the empty cell in the row below, Excel 2013’s AutoCorrect feature not only suggests the rest of that second entry to make, but also all the rest of the corresponding entries for the entire column.
To complete the AutoCorrect-suggested entry and fill out the entire column, you simply click the Enter button on the Formula bar or press the Enter key.