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.

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 …

This article describes the formula syntax and usage of the FIND function in Microsoft Excel. Description FIND locates one text string within a second text string, and return the number of …

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 …

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.

Match case Finds only those occurrences that have the exact combination of uppercase and lowercase letters specified in the Find what box. Matches the case of letters as they were …

Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These …

Find and replace text and numbers in Excel using keyboard shortcuts and a screen reader.