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