• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 8. Editing Worksheets > Replacing Data

Replacing Data

Open the Edit menu and select Replace. The Find and Replace dialog box opens with the Replace tab displayed.

In the Find What text box, type the data you want to find. Press the Tab key to move the cursor to the Replace with text box, and type the replacement data.

Click Replace All to replace all instances. (Or, click Find Next to find the first instance of the data, and then click Replace to replace it; repeat as necessary.)

Excel notifies you of the number of replacements it made; click OK. When you're finished using the Find and Replace dialog box, click its Close button to close it.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint