Text Functions
Intermediate
FIND and SEARCH Functions
Locate text within a string using FIND or SEARCH.
Task:
Find the position of the @ symbol in email addresses and extract the domain name.
Learning Objectives:
- Learn FIND and SEARCH functions
- Understand text position finding
- Practice extracting substrings
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | @ Position | Domain | |
| 2 | john@company.com | ||
| 3 | mary@business.org | ||
| 4 | tom@startup.net |
What this exercise teaches (contains the answer)
FIND and SEARCH return the starting position of one text string within another. FIND is case-sensitive, while SEARCH is not.