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

Replacing Data

The Edit Replace command lets you quickly locate and replace numbers, text, data formats, and special characters. Suppose you have text that you entered incorrectly or that has changed throughout a large worksheet. You can use the Edit Replace command to have Excel search for and replace all occurrences of the incorrect information with the correct information. You can find and replace data in three ways:

  • Replace the first occurrence of the data

  • Replace specific occurrences of the data

  • Replace all occurrences of the data


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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