Exercises / Cleaning text · 3 of 13
Split a SKU into its parts
LEFT(text, n) returns the first n characters and RIGHT(text, n) the last n. Codes with a fixed layout split cleanly this way.
Your taskEvery SKU starts with a 3-letter warehouse code, like NYC-0042. In B2, use LEFT to return the warehouse code. It will be copied down to B7.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B |
|---|---|---|
| 1 | SKU | Warehouse |
| 2 | NYC-0042 | |
| 3 | LAX-1180 | |
| 4 | CHI-0907 | |
| 5 | NYC-2215 | |
| 6 | DAL-0031 | |
| 7 | SEA-4410 |