Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
CLEAN. CLEAN(text) deletes non-printing characters such as line breaks and tabs. It leaves ordinary spaces alone, so pair it with TRIM: clean first, then trim, and you remove both kinds of junk in one formula.
=TRIM(CLEAN(B2)) on a pasted address with a line break at the end
Delivery notes were pasted into the CRM from a web form, which left invisible line breaks and tabs, and sometimes a space, around the text. The route planner prints them on one line, so they must be clean.
In B2:B7, return each note from column A with the non-printing characters removed and no spaces left at either end. Column C shows the cleaned length.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Note (import) | Note (clean) | Length | |||||
| 2 | Call before delivery | 15 | ||||||
| 3 | Net-30 terms | 15 | ||||||
| 4 | Use loading dock B | 15 | ||||||
| 5 | Prefers email | 15 | ||||||
| 6 | Closed on Mondays | 15 | ||||||
| 7 | Ask for reception desk | 15 | ||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 |
=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