App Icon
Lets you to easily find and replace text with other formatting in Sheets.
Listing updated:February 16, 2022
Works with:
9,778
Overview
Advanced Find & Replace add-on for Google Sheets revolutionizes your experience by saving your time to search and replace items such as text and/or/with formatting. Also lets you to extend your search by using regular expressions to find words or phrases that contain specific characters or combinations of characters.

Trial limitations: 30 attempts.

Features:
- Find and replace formatting with regular expressions
- Find using AND, OR, NOT formatting conditions
- Replace with escape characters
- Replace text or with formatting (below)
- Find & Replace with formatting such as
	* bold
	* italic
	* underline
	* top
	* middle
	* bottom
	* wrap
	* strikethrough
	* overflow
	* font name
	* font size
	* background color
	* foreground color
	* formula
	* notes
Additional information
PricingNot available
Developer
Trader status unspecified
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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
A User of Advanced Find & Replace for Sheets
May 16, 2017
Very successfully changed the background color of thousands of cells with just a few clicks. Thanks!
Is this review helpful?
Yes
No
Profile Picture
William Griffiths
September 16, 2021
It did not work for me at first but once I applied the activation code it worked great. This program is great.
Is this review helpful?
Yes
No
Profile Picture
Anony Dee
August 16, 2020
I could replace with formatting to my 230 Company spreadsheets in no time else I should have spent a week plus of hours. The Author is very helpful too. I am very thankful to him. Its a jewel to me.
Is this review helpful?
Yes
No
Profile Picture
Straw Gyssels
February 16, 2022
did not succed to replace the fill color of cells from one color to an other, also it wants you to pay after only 30 clicks?
Is this review helpful?
Yes
No
Profile Picture
Jamie Macdonald
January 18, 2021
Does not seem to be a way to do a bulk search and replace across many different workbooks, not as advanced as I had hoped..
Is this review helpful?
Yes
No
Profile Picture
Олег Шовкун
October 22, 2020
Great tool! How can I do regex replace for groups? E.g. replace [a-z](\d+) to $1 Example: a2545 will become 2545
Is this review helpful?
Yes
No
Profile Picture
A User of Advanced Find & Replace for Sheets
October 5, 2019
Do not bother with this if you seek the ability to replace Formatting on specific strings. Unlike that in Windows desktop Excel, Formatting change applies to the whole cell instead of the strings in the search result.
Is this review helpful?
Yes
No
Profile Picture
Jason Nowakoski
September 16, 2021
Great add on - much better than the default find and replace in google sheets. I had a small issue with getting it to work in the beginning and developer gladly assisted and fixed the issue right away. Definitely buy the premium, well worth it!
Is this review helpful?
Yes
No
Profile Picture
Hector Rojas
February 12, 2021
Not very advanced, I chose to replace with BOLD formatting and never once actually did it. Useless.
Is this review helpful?
Yes
No
Profile Picture
Karianne Holhjem Schirmer
August 8, 2021
I wanted to replace the background color of a bunch of empty cells to a different colour, but that was not possible.
Is this review helpful?
Yes
No
1-10 of 12
Search
Clear search
Close search
Google apps
Main menu