How to separate first and last names in Excel!

So, often you get a list of first and last names…and you want to separate them!

#Excel #spreadsheets

One dead simple way, is to use Flash fill in Excel (Ctrl+E)!

To do this, first – type out just the first rows first name and last name like so…

Then use Flash Fill! Just select cell C4 – “Andy”…and hit Ctrl + E!

Then do the same by selecting cell D4 – “Jenkins” and hit Ctrl +E as well!

You’ll see Excel will fill in the first names and last names below automatically!