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 …

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.

Use wildcard characters as comparison criteria for text filters and when you're searching and replacing content. These can also be used in the Conditional Formatting rules that use the …

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 …

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 …

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.

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.

The following illustration shows the result. You will need to wrap text on cell A4 to show the line breaks in the result.

If you're looking for a specific word or phrase in your presentation, workbook, or document, use Find to search for it. Find for iPhone and iPad Find for Windows Mobile Find for Android …

Select the replacement text, and press Ctrl+C (⌘+C on Mac) to copy it to the clipboard. Press Ctrl+F (⌘+F on Mac) to find on page, or Ctrl+E (⌘ + Option + F on Mac) search all open …