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.

Click on the Replace All button in the Find and Replace dialogue box to apply the new color to the text. Excel will alert you with the number of replacements made in the entire sheet or the ...

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

Do not confuse a space in the Replace With text field with an empty text field. If you press the space bar in the Replace With text field, Excel will replace all instances of that punctuation with ...

IFERROR can be used to eliminate formula errors and replace those errors with something else.

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.