Text Functions
Intermediate
LEFT, RIGHT, and MID Functions
Extract parts of text using LEFT, RIGHT, and MID functions.
Task:
You have phone numbers in a specific format. Extract the area code, exchange, and number parts using text functions.
Learning Objectives:
- Master LEFT, RIGHT, MID functions
- Understand text extraction
- Practice parsing formatted data
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 | D | |
|---|---|---|---|---|
| 1 | Phone Number | Area Code | Exchange | Number |
| 2 | (555) 123-4567 | |||
| 3 | (888) 987-6543 | |||
| 4 | (777) 456-7890 |
What this exercise teaches (contains the answer)
LEFT, RIGHT, and MID functions extract portions of text strings. They are essential for parsing formatted data like phone numbers, IDs, or codes.