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 ...

One obvious way to clean up data in Excel is to use the Find and Replace function, but Excel does a whole lot more.

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.