Lab › Data Cleaning › Split First and Last Name
Split First and Last Name: Excel Lab
Lab 17 · IntermediateLEFTMIDFIND
The task: Split each full name into a first name and a last name.
1 Watch how it is done
Step 1: First name: text before the space
=LEFT(A4,FIND(" ",A4)-1)- Click B4.
- Type =LEFT(A4,FIND(" ",A4)-1) and press Enter.
- FIND gives the position of the space. LEFT takes everything before it.
- Drag the fill handle down.
Step 2: Last name: text after the space
=MID(A4,FIND(" ",A4)+1,100)- Click C4.
- Type =MID(A4,FIND(" ",A4)+1,100) and press Enter.
- Drag the fill handle down.
2 Your turn
Download the practice file. It has new numbers. Open it in Excel (or Google Sheets) and do the same steps.
3 Check your answers
Stuck? Download the solution file and compare it with yours.
Next lab: Due Date and Day Name →
Want the theory? Read the Data Cleaning lessons →
← More Data Cleaning labs · All lab categories
