Advanced Find and Replace for Google Sheets

This add-on takes the native Find and replace feature from spreadsheets to the next level:

- search in several data types at once: values, formatting, formulas, notes, links, errors

- find & replace multiple values in Google Sheets in one go

- format, export or delete found values as well

- fuzzy search & regex

and more!

With Advanced Find and Replace at hand, you can forget about switching to each found value one after another. Instead, you will have all matching records grouped either by sheet or by search value with their cell address and data type. Simply click on the record in the list to select it in your sheet.

1. Run the add-on.
2. Enter the record to look for.
3. Specify the type of data to look in: formulas, values, formatting, etc.
4. Pick sheets or ranges to scan.
5. Set up any extra options to target the search.
6. Click Find.

All matching data will appear in a tree view, ready to be replaced one by one or all at once, or even formatted, exported or deleted whatsoever.

See a more detailed description here.

Replace all. To replace all values at once, enter the new text and click Replace all.

Replace selected. To change only some of the found records, select them in the add-on tree view, enter the replacement text, and click Replace.

Format. Change font/fill color of cells with the found records, make text bold, italic, underlined, strikethrough.

Delete. Click the corresponding icon to delete the rows with all or only the selected found entries.

Export. Choose the records you'd like to export and pick the destination: a new sheet, a new spreadsheet, or a custom location.

See a more detailed description here.

Yes! Either enter all the words you'd like to find separating them with spaces, or commas, or semicolons, or supply a range of cells that has these words.

The same for the replacement: either enter the words directly to the add-on or provide the range with replacements.

Yes. You can export all or only selected values or entire rows with these values to 3 places of your choice:

1. new sheet within the current file
2. new spreadsheet entirely
3. custom location: range of cells within the current file