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.