Lab › Data Cleaning › Make Email IDs
Make Email IDs: Excel Lab
Lab 16 · Beginner& (join text)LOWERLEFT
The task: Make an office email ID (first.last@company.com) and initials for every employee.
1 Watch how it is done
Step 1: Join the parts, make it small letters
=LOWER(A4&"."&B4&"@company.com")- Click C4.
- Type =LOWER(A4&"."&B4&"@company.com") and press Enter.
- & joins text. LOWER makes it all small letters.
- Drag the fill handle down.
Step 2: Initials
=LEFT(A4,1)&LEFT(B4,1)- Click D4.
- Type =LEFT(A4,1)&LEFT(B4,1) 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: Split First and Last Name →
Want the theory? Read the Data Cleaning lessons →
← More Data Cleaning labs · All lab categories
