Free SUBSTITUTE Formula Generator
Substitutes new text for old text in a text string. Great for data cleaning.
Generated Formula
=SUBSTITUTE(text, "old", "new")Learning Resources
Want to master Excel? Check out this Top-Rated Course.
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More