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.