Help & Support
Send Feedback
Advanced Find and Replace
Search in values, formulas, notes, hyperlinks in all sheets at once. Get the list with the found entries and replace them in a click
733 users
Works with
Install
Overview
Use this simple add-on for advanced search in your google spreadsheet. Find and replace text within a formula, check links hidden behind the display text, search within notes, and look for values at the same time. You can search and replace within a column by simply selecting the necessary range of data, or choose to scan any selected sheets. The add-on will display the list of all found records organized by sheet and take you to any found cell in a click. 
It's easy to use and it offers all you need to discover the necessary data:
	- Look at values, formulas, notes, errors and links simultaneously 
	- Find and replace in a single column or search everywhere in the spreadsheet 
	- Get all matches listed in the sidebar, navigate to any entry in a click  
	- Replace all or only the selected records
	- Export the found values or the entire rows that contain them

What's new?
Version 1.7
New Features:
- New type to look in - Errors. Now you can perform search in errors.

Improved:
- UI; we increased space for the "Search in" area which is useful for the documents with numerous sheets.
- Minor UX improvements.

Fixed:
- The add-on didn't find links in the range.
- If you were looking for hyperlinks only, the add-on showed cells with formulas too.

Version 1.6:
- Improved UI
- Fixed export issue 
- Minor bugs fixed
- We introduced yearly subscriptions, you can still enjoy a fully-functional trial version of the add-on for 30 days.

Advanced Find and Replace add-on will help you complete any substitutions in your sheets in seconds. If you have any questions about it, please post them here: https://www.ablebits.com/docs/howto-find-replace-google-values/
We'll be happy to assist!
Please visit the Chrome Web Store if you would like to reply or rate a review for this app.
Reviews
A User of Advanced Find and Replace
May 2, 2019
This has been indispensable while doing a silly personal project that involved converting a lot of numbers to point totals. It has been very easy to use while easing my mind as as much as i enjoy trying to compute things in my head, this completely removed personal error.
Submit reply
Cancel
A User of Advanced Find and Replace
January 29, 2019
Saves me hours upon hours and helps me build dashboards to reveal all sorts of insights at work. Would never be able to maintain them and adapt to changes without it.
Submit reply
Cancel
A User of Advanced Find and Replace
December 13, 2018
I have always liked the time saving aspect of the add on but in the last year it has been hit or miss for accuracy. Seems as though once it was updated and it became a paid subscription, it started flaking out. I am not pleased with the accuracy for the price tag that has been assigned. I keyed in the exact info 30 times back to back and it would give me different responses each time. I searched my name on one sheet and 19 out of 30 times it popped up with No Matching Data Found. Not $30.00 odds when you have to manually do the job that often. I often times get error messages, it times out or locks up. I would love to see more accuracy and less glitchy for the price tag that it currently holds
Submit reply
Cancel
A user of Advanced Find and Replace
December 13, 2018
Edit to add: My name is the first of 200 names on my sheet!
Byington Winery
October 22, 2018
Not ready to subscribe ..
Submit reply
Cancel
Lawana Hawkins
September 19, 2018
I love it because at this time it is serving my purpose. I will warn you that it is case sensitive. If you are doing a name search, you must search for the name as you entered it. If you use caps for the first or last name. you must do so in the search.
Submit reply
Cancel
A user of Advanced Find and Replace
September 26, 2018
Thank you very much for your feedback, Lawana! The add-on is actually case sensitive if you make it so :) There's an option "Match case" right below the field for entering names. If you UNcheck the box for that option, the add-on will find the records no matter their case.
A User of Advanced Find and Replace
August 27, 2018
Not worth a subscription. I'll spend the hour it takes to make my own add-on for searching within formulas, thanks..
Submit reply
Cancel
Aaron Reiss
June 5, 2018
Amazing, super time saving
Submit reply
Cancel
A User of Advanced Find and Replace
June 3, 2018
Absolute horseshit. This add-on would have been good, in fact it was. But they started forcing people to pay 30$ a year for it, which is absolutely insane. I would not recommend it at all.
Submit reply
Cancel
A User of Advanced Find and Replace
May 30, 2018
the only reason it gets any stars is because it works. If it wasn't for getting a stupid popup EVERY TIME i search for something that i have to go close, i would give it 5 stars. i could tolerate the once every 10 searches or so, but every time is just ridiculous. this has spawned a new effort to search for a new way to perform my task so i can remove this.
Submit reply
Cancel
A User of Advanced Find and Replace
May 21, 2018
Now they charge $30 a year
Submit reply
Cancel
1-10 of 29
Additional information
Search
Clear search
Close search
Google apps
Main menu