Excel's "Find and Replace" feature will search an entire spreadsheet or selected cells for your specified text. Excel also offer a "Replace" function.

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

Say that you have hundreds of similar Excel workbooks in a folder and you need to globally change “2009 Budget” to “2010 Budget” in all of the workbooks.

This approach results in a single spellcheck operation for the entire document, which is much faster than performing 42 individual search-and-replace operations. If your Excel’s spellcheck dictionary ...

Remove a Formula in Excel In some cases, you may use an Excel formula to do a multi-step calculation but you'd prefer to simply replace the results by the actual number rather than by the formula.