Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can …

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.

The REGEXREPLACE function allows you to replace text from a string with another string, based on a supplied regular expression ("regex"). Syntax The REGEXREPLACE function replaces …

These can also be used in the Conditional Formatting rules that use the "Only format cells that contain specific text" criteria. For more about using wildcard characters with the Find and …

Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in …

Microsoft Excel shows the #DIV/0! error when a number is divided by zero (0). It happens when you enter a simple formula like =5/0, or when a formula refers to a cell that has 0 or is blank, …

In Power Query, you can replace one value with another value in a selected column. You can replace specific values or the whole value in a cell. Replacing values in a query does not edit …

When you replace formulas with their values, Excel permanently removes the formulas. If you accidentally replace a formula with a value and want to restore the formula, select Undo …

You can replace a formula with its calculated value so that the formula no longer recalculates. Replacing a formula with its static result can help improve performance if the workbook …