Advanced search doesn't have to be complicated! 😉 With all options in checkboxes, you're in control. Get all matches grouped by sheet or value, and effortlessly navigate to each cell with a click. Replace, color, extract, delete, and revamp formatting – for all or selected matches in one go! 🚀 Advanced Find and Replace is your ultimate solution for seamless search & replacement in Google Sheets!

🔎 Look in:
🗸 values
🗸 formatting
🗸 URLs
🗸 URL labels
🗸 formulas
🗸 errors
🗸 error descriptions
🗸 notes

🔥 Extra support for:
🗸 simultaneous search for multiple words/phrases
🗸 regular expressions (for pattern-based search)
🗸 fuzzy search (for approximate matches)

🎯 Search within:
🗸 current sheet
🗸 all sheets
🗸 selected range
🗸 multiple specific ranges

⚡ Handle all or only selected found records:
🗸 Delete entire rows
🗸 Replace
🗸 Replace with corresponding values from your list
🗸 Color found cells or text in found cells
🗸 Format (bold, italics, underline, strikethrough)
🗸 Export to a new sheet, file or hand-picked destination range

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:
*****V2.0***** (09 Jul 2024)
★ New features ★
- Meet the brand-new version with lots of new search & replace possibilities!
- Find & replace multiple values:
  - Enter several values separated by space/comma/semicolon to find them all at once.
  - Or copy-paste your list of words into the search field. 
  - Find & replace multiple values with their corresponding alternatives from a provided list.
- Find & replace entire cell formatting: bold, italic, underline, strikethrough, fill color, font color.
- Search & highlight: color found cells, change font color.
- Search numbers by condition: use comparison operators such as >, <, =, <>, <=, >=
- Search by formula results, e.g. =A2*0.5
- Search by any regular expression you want, e.g. \d+
- Fuzzy search: fine-tune the search precision by choosing the number of allowed fuzzy chars.
- 2 new locations to export found values: to a new spreadsheet and a certain range of cells within the current file.

Improved:
- Enjoy the new friendlier design!
- We've refined the 'Search within' options for a more straightforward experience. New options are: Current sheet, All sheets, Selected range, Specific ranges.
- Identify all currency numbers no matter their format, unless you explicitly include the currency symbol in your search.
- See the total number of found values & of the values you select to handle.
- The tab with found results now supports your keyboard. Use Tab, arrows and Enter keys to move through the list and select the options to manage the found values.
- Results are grouped by sheet by default, but you can regroup by search value. Expand/collapse the groups for better navigation experience.
- UX and UI improvements.

Fixed:
- Couldn't process data that contained some non-printing characters.
- Couldn't recognize some types of hyperlinks.

*****V1.11 (17 Apr 2023) *****
Improved:
- Minor UX and UI improvements.

Fixed:
- Couldn't replace and export the data from the sheets with 2 numbers at the beginning of their names.
- Didn't export dates when exporting rows with all found entries.
- Displayed sheet names incorrectly if they had leading spaces.
- Cut zeros and leading spaces from the names of the sheet on the exported sheet.

*****V1.10 (28 Jul 2022) *****
Improved:
- The limit for total cells in a spreadsheet is expanded to 10 million cells.
- Further performance improvements made it possible to export more found records than before.
- Minor UX and UI improvements.

Fixed:
- Couldn't display results for more than 8k found records.
- Couldn't replace data in cells with duplicate records formatted as rich text.
- Didn't show the list of all sheets if at least one sheet name ended with 2 underscores (__).

***** V1.9 (5 May 2021) *****
★ New features ★
- Preserve text formatting. If there are multiple text strings in a cell formatted in different ways, this option will let you keep all formatting upon replacing values.

Improved:
- Significant performance improvements in processing large amounts of data.
- Minor UI improvements.

Fixed:
- Didn't search in hyperlinks if they weren't created by the corresponding function.
- Didn't export cells and rows with found errors.
- The list of sheets didn't update in the tree view if sheets were added/deleted from a file with the add-on opened.
- The addresses of found records didn't update after deleting rows with found entries.
- Couldn't find anything if the chart sheet was selected to search in as well.
- Minor UX issues.

***** V1.8 *****
★ New features ★
- Delete rows with all found entries or delete rows only with those found values that you select in the add-on.

Improved:
- The add-on remembers the sheets you search in: the same sheets will be selected the next time you run the tool.

Fixed:
- The add-on didn't look for notes in empty cells.
- There were problems with locating all Booleans (TRUE/FALSE).
- Treated cells containing a question mark as cells with errors.
- Minor UX issues.

***** V1.7 *****
★ New features ★
- New type to look in - Errors. Now you can perform a 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.

***** V1.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.