Course
LEFT, RIGHT and MID practice exercises
Five exercises, from a two-letter country code to splitting full names of any length. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Read the LEFT, RIGHT and MID tutorial
Exercise 1 of 5
Take the country code from an order ID
In C2, use LEFT to take the first two characters of the order ID in A2, to get the country code US.
| Order ID | Customer | Country code |
| US-20431 | Northwind Foods | |
| CA-20432 | Bluebird Studio | |
| GB-20433 | Harbor Logistics | |
| AU-20434 | Maple Dental | |
| US-20435 | Cedar Books |