Google recently announced Add-on gallery for their cloud word processing suite integrated with the Google Drive. Here is the first add-on that I am introducing you guys to: Advanced Find and Replace Add-on for Google Sheets.
What can I do with this add-on?
Search in values, formulas, notes, hyperlinks in all sheets at once. Get the list with the found entries and replace them in a click.
Advanced Find and Replace add-on will help you complete any substitutions in your sheets in seconds.
You can look for the record you need in hyperlinks hidden behind the display text, formulas, and even notes. The search in values is performed with advanced parameters as well: you can match case, retrieve the cells that contain only the exact entry, or get any text occurrences.
This Google Sheets add-on is very easy to work with:
– Enter the value, choose its type and the sheets to search in
– See all matches listed in the sidebar
You can add this to your Google Sheets from here.