FormuladrillSUBSTITUTE practice
SUBSTITUTE replaces every occurrence of one text with another. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.
Syntax
SUBSTITUTE(text, search_for, replace_with, [occurrence_number])
What people get wrong
Use it to strip dashes or spaces from phone numbers before VALUE turns them into numbers.
Excel exercise that use SUBSTITUTE
- Digits onlyLevel 4Pro
Practice SUBSTITUTE now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free