Task 1 of 5
In D2:D6, make the city code: the first 3 letters, in capitals.
Lesson theory
You are preparing name badges for conference attendees. Practice LEFT, MID, FIND, UPPER, SUBSTITUTE and CONCAT.
Tip: when words have different lengths, find the position of a space with FIND(" ",A2) and cut the text from there.
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.