Text Functions
Intermediate
SUBSTITUTE Function
Replace specific text within a string using SUBSTITUTE.
Task:
Update email addresses in column A by replacing the old domain with a new domain. Display the updated emails in column B.
Learning Objectives:
- Learn SUBSTITUTE function
- Understand text replacement
- Practice find and replace operations
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 | |
|---|---|---|
| 1 | Old Email | New Email |
| 2 | john@oldcompany.com | |
| 3 | mary@oldcompany.com | |
| 4 | tom@oldcompany.com |
What this exercise teaches (contains the answer)
SUBSTITUTE replaces specific text within a string. Unlike REPLACE, it works with the actual text content rather than character positions.