Lets you to easily find and replace text with other formatting in Sheets™.
Listing updated:June 26, 2024
Works with:
The Advanced Find & Replace add-on for Google Sheets™ transforms your spreadsheet experience by providing powerful search and replace functionalities, allowing you to handle both text and cell formatting efficiently. Save time and increase productivity with advanced options such as regular expressions and formatting conditions to refine your search.


- Advanced Search and Replace:
  - Find and Replace with Regular Expressions: Utilize regular expressions to find complex patterns and combinations of characters, enabling highly specific searches.
  - Conditional Searches: Use AND, OR, and NOT conditions to refine your searches and target exactly what you need to find or replace.
  - Escape Characters: Replace text using escape characters to handle special symbols and sequences accurately.

- Comprehensive Formatting Support:
  - Bold: Find and replace text with bold formatting.
  - Italic: Search for and replace italicized text.
  - Underline: Locate and replace underlined text.
  - Top, Middle, Bottom Alignment: Adjust text alignment settings in cells.
  - Text Wrapping: Find cells with text wrapping enabled and modify them.
  - Strikethrough: Identify and replace text with strikethrough formatting.
  - Overflow: Find cells with text overflow settings and adjust them.
  - Font Name and Size: Search for specific font names and sizes to standardize or update your sheet's appearance.
  - Background Color: Find and replace cells with specific background colors.
  - Foreground Color: Search for and update cells based on text color.
  - Formulas: Locate and replace formulas within your sheet.
  - Notes: Find and modify cell notes for better information management.

Free Version Limitations:

- 30 Attempts: The trial version allows you to use the advanced features up to 30 times, providing a glimpse into the full capabilities of the add-on.

Revolutionize your spreadsheet workflow with the Advanced Find & Replace add-on for Google Sheets™. Upgrade to the premium version for unrestricted access and advanced capabilities. Start making your data management more efficient today!

Video help: https://www.youtube.com/watch?v=2OoD8jECizQ&list=PL1ULeCgpH_H_2NDhB_2O4Be7wK7aC-eV4

* Google services impose daily quotas and hard limitations on some features - https://developers.google.com/apps-script/guides/services/quotas

- Advanced Find & Replace use and transfer of information received from Google APIs to any other app will adhere to Google API Services User Data Policy, including the Limited Use requirements.
Additional information
PricingFree of charge with paid features
Privacy policy
Terms of service
Advanced Find & Replace for Sheets™ will ask for the permissions shown below. Learn more
Advanced Find & Replace for Sheets™ will need access to your Google account
This will allow Advanced Find & Replace for Sheets™ to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Lulenka Steinhauser
June 28, 2024
Its not working??
Is this review helpful?
1-1 of 1
Clear search
Close search
Google apps
Main menu