Find and replace

Find and replace

To find and replace data:
  1. Go to Home > Search 
  2. Select Find from the contextual menu.
  3. Enter the text you wish to find in the input field.
  4. Choose if you wish to search within a sheet, range or the entire spreadsheet, and click Find.
  5. Once the results appear, click Replace.
  6. Enter the value you'd like to replace with.
  7. Click Replace to modify each occurrence individually, or click Replace All to modify all occurrences at once.