If you’re creating a worksheet from scratch, you might be happy typing all of your data by hand. You can use the new Flash Fill feature in Excel 2013 to speed up the process and help you along the way.
Click the cell into which you want to enter text.
Type the text that you want in the cell.
Press the Enter key.
In the cell to the right of the first item in the data list, type the string you want to extract from the first value in the list.
In the cell to the right of the second item in the data list, type the string you want to extract from the second value ...