Advanced Find and Replace for Google Sheets

The add-on offers an enhanced way to find and replace data in Google Sheets. Its advanced options provide a thorough scan across multiple spreadsheets or within the selected range. Enter the search query and pick other criteria: consider text case and data type, or retrieve the cells that contain only the exact entry. The add-on will get the most precise results by picking all relevant items.

Our add-on finds and replaces data in Google Sheets formulas, notes, hyperlinks, and errors.

With this tool at hand, you can forget about switching to each found value one after another. You will see all matching records listed with their cell address and data type. Simply click on the record in the list to select it in your sheet.

You can also change multiple values with a click. And if you'd like to bring the search results to a separate sheet or remove from the sheets completely, simply export or delete them with any adjacent data.

1. Run the add-on.
2. Enter the record to look for.
3. Specify the type of data to search within: formulas, values, notes, etc.
4. Check the sheets you’d like to scan.
5. Click Find all.

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.

Export. To export values, click on the icon with three dots right above the list of found results and choose records to transfer.

Delete. To delete the rows with all or only the selected found entries, click the same icon with three dots and select the required option.

See a more detailed description here.

Yes, if you decide to make it so. :) A special Match case option lets you differentiate between the same records written in various cases.

Our tool searches in Google Sheets values, formulas, notes, hyperlinks, and errors.

Sure! The option called By mask and a couple of wildcard characters will help you indicate the pattern of the values to look for.

For example, to see the list of all errors, tick off By mask along with Errors to look in. Then enter the asterisk (*) into the Find what field and press Find all — the tool will do the rest.

No, Advanced Find and Replace remembers the options you check and keeps them that way for you on the next run. You’ll only need to enter the text to search for and hit Find all.