Ablebits
•  55,540
Overview
Search in values, formulas, notes, hyperlinks in all sheets at once. Get the list with the found entries and replace them in a click
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!
Reviews
Language:
Sort by:
A User of Advanced Find and Replace
May 27, 2020
It's just a bit slow in finding things
Is this review helpful?
Yes
No
A user of Advanced Find and Replace
May 28, 2020
Thank you for your feedback. The processing speed of the add-ons depends on your Internet connection speed, your computer operating memory, and the amounts of data you have in your spreadsheets. Thus, adding more memory or switching to a more powerful computer may help speed up the work of the tool.
A User of Advanced Find and Replace
March 3, 2020
Nice
Is this review helpful?
Yes
No
A User of Advanced Find and Replace
February 18, 2020
Didn't work. Even if all pages/sheets selected, it wouldn't find the search value.
Is this review helpful?
Yes
No
A user of Advanced Find and Replace
February 19, 2020
Hello, Please use the Support link under the comments section to contact our support team. We'll look into the problem and make the tool work for you.
A User of Advanced Find and Replace
January 8, 2020
Wonderfully powerful add-on to Google Sheets! I am always impressed by the consistent innovation and improvements made by Ablebits.
Is this review helpful?
Yes
No
A User of Advanced Find and Replace
December 4, 2019
Did not tell me upfront that it was a paid addon and under "free trail". I've wasted time training my employee to use it and now feel pressured and tricked to Pay.
Is this review helpful?
Yes
No
A user of Advanced Find and Replace
December 10, 2019
Hello, The trial 30-day version is mentioned in the tool itself, the description here on G Suite Marketplace as well as our website. We'll try to make it more clear in the future.
A User of Advanced Find and Replace
October 22, 2019
the app works great, the ridiculous amount of ratings requests is a total pain in the a**. I have better things to do than this.
Is this review helpful?
Yes
No
A user of Advanced Find and Replace
October 23, 2019
Hello there, When the add-on asks you to rate it, you can click the No, thanks button and you won't see the message again. If you click Later, the message will appear again.
A User of Advanced Find and Replace
September 29, 2019
Really great with a lot of options I need to do my work.
Is this review helpful?
Yes
No
Katie Chavez
August 9, 2019
This feature was great before it became something you had to pay for. Ever since I signed up and paid for the subscription it's nowhere near as accurate as it was before it became something you pay for. I can search for something that I can literally see in a cell on the screen and the add-on doesn't find it. They need to make improvements before I renew next year.
Is this review helpful?
Yes
No
A user of Advanced Find and Replace
August 12, 2019
Hello Katie, So sorry to hear you've encountered difficulties with our add-on. Please email us to support@ablebits.com with the details of the issue. We'll look into it. Thank you.
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.
Is this review helpful?
Yes
No
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
Is this review helpful?
Yes
No
A user of Advanced Find and Replace
December 13, 2018
Thank you very much for your feedback, Sandy. I'm really sorry to hear you've encountered this difficulty. We would appreciate a lot if you could contact our support team (support@ablebits.com) with the example of your data and the screenshot of the settings you select in the add-on. If you see any error messages again, please send us their screenshots as well. We'll investigate the issue and see what may be causing the problem. Since we've never been reported of this before, for now I can only advise you to make sure you're not logged in to multiple accounts (the issue on the side of Google) and your Internet connection speed is fast and stable. Thank you in advance for your assistance.
A user of Advanced Find and Replace
December 13, 2018
Edit to add: My name is the first of 200 names on my sheet!
1-10 of 35
Additional information
Ablebits
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu