Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
FIND. FIND(find_text, within_text) returns the position of the first match, counting from 1. It turns a moving separator into a number you can use inside MID, LEFT or RIGHT. FIND is case-sensitive and gives #VALUE! when there is no match.
=FIND("-","North-07") gives 6Sales wants to group CRM contacts by company. The company is in the email domain, everything after the @, and names have different lengths so the @ is never in the same place.
In C2:C9, return the domain of each email in column B (the text after the @, without the @ itself), for example meadowclinic.com.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Contact | Domain | ||||||
| 2 | Maria Hart | maria.hart@meadowclinic.com | ||||||
| 3 | Kevin Hart | kevin.hart@orchardlogistics.com | ||||||
| 4 | Kevin Garcia | kevin.garcia@graniteclinic.com | ||||||
| 5 | Emma Jensen | emma.jensen@riverdental.com | ||||||
| 6 | Julia Stone | julia.stone@cedarrealty.com | ||||||
| 7 | Rachel Price | rachel.price@northacademy.com | ||||||
| 8 | Leo Fox | leo.fox@falcondental.com | ||||||
| 9 | David Walsh | david.walsh@atlasconsulting.com | ||||||
| 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