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.

You can find and replace text with special formatting, such as bold or highlight, by using the Format menu. On the Format menu, select the replacement formatting. If a second dialog box …

If you’re working with a lot of text and need to search and replace a word or a phrase, use Find and Replace in your Office app. Select Replace or press Ctrl + H.

Unlike Microsoft Word, Microsoft Excel doesn't have a Change Case button for changing capitalization. However, you can use the UPPER, LOWER, or PROPER functions to …

With Power Query, you can replace one value with another value in a selected column.

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 …

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 …

Enter a word or phrase you want to find in your document or workbook. Once you've entered your query, you'll see a numerical indicator in the search box of how many times that word or …