Exercises / Cleaning text · 13 of 13
Check that every code is 8 characters
LEN(text) returns the number of characters, spaces included. It is the quickest way to catch codes that are too short or too long.
Your taskA valid product code has exactly 8 characters. In B2, use LEN and IF to return "OK" when the code in A2 has 8 characters, and "Check" otherwise. It will be copied down to B8.
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 | Code | Status |
| 2 | AB12CD34 | |
| 3 | XY99ZZ1 | |
| 4 | QW45ER67 | |
| 5 | MN23OP456 | |
| 6 | GH78JK90 | |
| 7 | TT11 | |
| 8 | LP30KM08 |