Learn how to separate first name and last names.

METHOD 1: Using Ctrl + E
Here are the steps.
1) Enter first name.
2) Go to any cell below that cell.
3) Ctrl + E
5) Enter last name.
4) Repeat step 2 to 3.

This shortcut works in all versions of Excel, from Excel 97 all the way up to Excel 2016. And it works in all types of cells, including cells that contain text, numbers, and formulas.

METHOD 2: Using formula
Use this formula for first name.
=LEFT(A2,(FIND(/” /

Please take the opportunity to connect and share this video with your friends and family if you find it useful.