Question 1 of 10
=SUBSTITUTE(A3, "York", "Jersey")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Minnesota | |||
| 2 | California | |||
| 3 | New York | |||
| 4 | Florida | |||
| 5 | Illinois |
SUBSTITUTE Function - Free Excel Practice Online
This free, interactive exercise teaches you SUBSTITUTE Function in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Text Manipulation Functions track and works right in your browser - no Excel install, no download, and no signup.
Practising SUBSTITUTE Function this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.
What you'll practice in this SUBSTITUTE Function lesson
- The SUBSTITUTE function replaces some text in a specified cell with a new string of text. To get a string of text that says "New Jersey", try typing =SUBSTITUTE(A3, "York", "Jersey")
- The SUBSTITUTE function replaces ALL instances of the second argument with the third argument. To get a string that says "Roof", try typing =SUBSTITUTE(A3, "e", "o")
- The SUBSTITUTE function is CASE SENSITIVE, so "P" and "p" are considered different characters. Try writing a SUBSTITUTE formula that returns "Plotting".
- The SUBSTITUTE function has a fourth optional argument, which specifies which instance of the specified string is replaced. For example, =SUBSTITUTE(A1, "l", "u", 1) will only replace the first "l" in the string. What will the formula return?
- Use the SUBSTITUTE function with the instance argument to return "committed"
- Use the SUBSTITUTE function WITHOUT the instance argument to return "committed"
- Use the SUBSTITUTE function to return "Beekeeper"
- What would =SUBSTITUTE(A1, "e", "d", 3) return?
- Write a SUBSTITUTE formula that returns "Suffix"
- What would =SUBSTITUTE(A1, "i", "a") return?
SUBSTITUTE Function practice - FAQ
How do I practice SUBSTITUTE Function in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the SUBSTITUTE Function exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this SUBSTITUTE Function lesson?
This lesson covers SUBSTITUTE Function as part of the Text Manipulation Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.