Finding and Replacing Text

After you’ve entered data into a workbook, you might need to search the document for a particular word or, if one of your suppliers changes the name of a product, replace some or all instances of a word or phrase. You can do just that using Find and Replace in Excel.

Find a Word or Value

  1. Click the Home tab.

  2. In the Editing group, click Find and Select.

  3. Click Find.

  4. Type the text you want to find.

  5. Click Find Next.

  6. Click Close.

    Find a Word or Value

Replace a Word or Value

  1. Click the Home tab.

  2. In the Editing group, click Find and Select.

  3. Click Replace.

  4. Type the text you want to replace.

  5. Type the text you want to take the place of the existing text.

  6. Click Find Next. Follow any of these steps:

    • Click Replace to replace the text.

    • Click Find Next to skip this instance of the text and move to the next time it occurs.

    • Click Replace All to replace every instance of the text.

  7. Click Close.

    Replace a Word or Value
    Replace a Word or Value

    Caution

    Caution

    Clicking Replace All is a quick way to change every occurrence of one value to another value, but it can also have unintended consequences. For example, changing "ear" to "bear" would change "hearing" to "hbearing." It’s much safer to use Find Next and verify each change.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.116.60.158