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.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of LEFT, RIGHT, MID
0/4The same formula in the other shapes it takes at work.
- LEFT, RIGHT, and MID Functions
Extract parts of text using LEFT, RIGHT, and MID functions.
CoreIntermediate - LEFT up to a space: the first name
When the length changes from row to row, let FIND work it out.
Intermediate - RIGHT after a space: the last name
Count from the end: total length minus where the space is.
Intermediate - MID between two separators
Pull the middle section out of a code when every part varies in length.
Advanced
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 teachesMay contain 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.