App Icon
Ablebits
•  122,625
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 displayed text, search within notes, and look for values at the same time. You can search and replace within a column by selecting the necessary range of data, or scanning 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

30 DAYS OF FREE USE
Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions about the add-on, please post them here:
https://www.ablebits.com/docs/google-sheets-find-replace-values/
We'll be happy to assist!

Advanced Find & Replace is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
––––––––––
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.
Reviews
Language:
Sort by:
Profile Picture
Mingzhong Chen
April 9, 2021
Help to save so much time, Thanks!
Is this review helpful?
Yes
No
Profile Picture
Kevin Ta
February 13, 2021
Was able to search and replace numbers in formulas -- saved hours of work!
Is this review helpful?
Yes
No
Profile Picture
Gretchen Leslie
January 25, 2021
This just saved me HOURS of work. Fantastic tool!
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 10, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
Profile Picture
Troy Pasulka
November 25, 2020
Works great!
Is this review helpful?
Yes
No
Profile Picture
Hari Neupane
October 29, 2020
Good add on but search is bit slow.
Is this review helpful?
Yes
No
Profile Pciture
Natalia Sharashova
October 30, 2020
Hello Nari, 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. Adding more memory or switching to a more powerful computer may help speed up the work of the tool.
Profile Picture
Pierre Beneby
October 22, 2020
Worth the price. I work in Google Sheets daily from home now and I have access to 2k+ files that I must manage daily. This search add on is a must. Not perfect but definitely worth the cost.
Is this review helpful?
Yes
No
Profile Pciture
Natalia Sharashova
October 23, 2020
Thank you for your feedback. You mentioned that the add-on is not perfect: could you tell us why? What is it that the add-on lacks to your opinion? We may be able to add a missing feature or let you know if it's already in the development.
Profile Picture
Katie Kline
October 5, 2020
Exactly what I was looking for to be able to make wholesale replacements to character strings in cell formulas. Works great!
Is this review helpful?
Yes
No
Profile Picture
Cindy Scott
October 1, 2020
Advanced find love it
Is this review helpful?
Yes
No
Profile Picture
Jennifer Smith
September 16, 2020
Saved me countless hours and headaches in just a couple of weeks of use. Intuitive, reliable. Highly recommend.
Is this review helpful?
Yes
No
1-10 of 49
Additional information
Ablebits
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu