Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
TEXTJOIN. TEXTJOIN(separator, ignore_empty, range) joins every cell in a range with the separator between them. Set ignore_empty to TRUE to skip blank cells; with FALSE, each blank still adds a separator, leaving stray commas.
=TEXTJOIN(" / ",TRUE,B2:D2) gives North / West when C2 is emptyThe delivery note shows what is in each July order on one line. The order export has up to four item columns, and smaller orders leave some of them empty.
In G2:G8, join the items in C:F of each row into one text, separated by a comma and a space (", "), skipping empty item cells. Use TEXTJOIN.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Customer | Item 1 | Item 2 | Item 3 | Item 4 | Items | |
| 2 | 50600 | River Dental | Notebook A5 (10) | Label Roll (1000) | Hand Soap Refill 5L | |||
| 3 | 50602 | Cedar Realty | Tea Assortment (200) | Toner Cartridge Color | ||||
| 4 | 50604 | Maple Bakery | All-Purpose Cleaner 5L | Sticky Notes (24) | Notebook A5 (10) | Oat Milk 12-pack | ||
| 5 | 50606 | Cedar Bakery | Oat Milk 12-pack | |||||
| 6 | 50609 | Willow Dental | Trash Bags (200) | Paper Cups (1000) | Paper Towels (24) | Filter Coffee 1kg | ||
| 7 | 50611 | Lakeside Motors | Sugar Sticks (1000) | |||||
| 8 | 50613 | Lakeside Studios | Espresso Beans 1kg | Trash Bags (200) | Notebook A5 (10) | |||
| 9 | ||||||||
| 10 | ||||||||
| 11 |
=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