Extract First Names and Last Names from a cell

Suppose you have a series of names in the A column, and that the first and last names are all typed in the same cell:
excelguy.co.za

What you want to do, however, is to have the first names in the A column and the last names in the B column. Is there an easy way to do this? Yes – use Flash Fill!

 

 

excelguy.co.za

Create a simple spreadsheet like the one in the image above. Click inside cell B2. Enter the first name of Ken. Press the enter key on your keyboard. This will select cell B3. Perform a Flash Fill by holding the CTRL key and pressing the letter E. Excel will finish adding the first names to cells B3 to B7:

 

 

excelguy.co.za

Now click inside cell C2. Enter the last name Carney. Flash Fill the rest of the last names down to cell C7:

Notice that Flash Fill has added the heading Names to cell C1. You can delete this, if you like. (Just click inside cell C1 then hit the delete key on your keyboard.) We can now delete the entire A column, because we don’t need the full names. Highlight the entire A column by clicking on the letter A column heading: