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
- Replace all or only the selected records
- Export the found values, or get the entire rows with the entries
Finding and replacing data in your worksheets is a breeze with this tool at hand.
If you have any questions about the add-on, please post them in our community: http://goo.gl/5aqwsD