Substitute and Replace functions are text functions. We explain how to use the Substitute and Replace functions in Microsoft Excel.

The Excel function SUBSTITUTE can replace symbols, numbers, or text. We explain how to use SUBSTITUTE function in Excel effectively.

Excel functions: 7 ways to use Text functions to manage data How to replace words; extract first and last words, matched or a specific words in a string of text By JD Sartain Dec 14, 2017 3:30 am PST ...

Microsoft doesn't mind if you stop using Excel for the wrong things, as it's been building replacements to compete with the tools trying to replace Excel for doing things it wasn't designed for.

I’m happy to tell you there is a great keyboard substitute, it’s called the Series, and it works in all editions of Excel. To access Series, select the cells you want to fill.