Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
TRIM. TRIM(text) removes spaces at the start and end of a text and squeezes runs of spaces inside it down to one. Imports and copy-paste often add invisible spaces, which break lookups and counts. The text looks the same; LEN shows the difference.
=TRIM(" Harbor Realty ") gives Harbor RealtyThe CRM import padded many customer refs with spaces, so " C-1053 " no longer matches C-1053 in the customer list. Column C shows each cleaned ref’s length; a clean ref is 6 characters.
In B2:B9, return each customer ref from column A without its leading and trailing spaces. Column C will show 6 on every row when you are done.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Ref (import) | Ref (clean) | Length | |||||
| 2 | C-1053 | 15 | ||||||
| 3 | C-1065 | 15 | ||||||
| 4 | C-1110 | 15 | ||||||
| 5 | C-1016 | 15 | ||||||
| 6 | C-1047 | 15 | ||||||
| 7 | C-1010 | 15 | ||||||
| 8 | C-1061 | 15 | ||||||
| 9 | C-1092 | 15 | ||||||
| 10 | ||||||||
| 11 | ||||||||
| 12 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe