Google Sheets - Find and Replace with Functions or Without SUBSTITUTE, RegEx, Wildcards Tutorial

Learn how to use Find and Replace in Google Sheets, from basic to advanced tutorial. You'll learn how to do search & replace without using formula & using functions SUBSTITUTE & REGEXREPLACE for advanced regular expression replacement using special characters and wildcards to search your text for patterns and do full or partial replace if there is a match.

[Deatarus]

This is the best "Find and Replace" video on the entire goddamn internet. After hours of searching I finally found my answers. THANK YOU.

[MisterFme]

6 years old yet what a great video. Thank you for this awesome explanation.

[penny]

Exactly what I was looking for! You don’t know how much you’ve made my work so much easier. Great info. Thank you so much! 🙏

[pamelan]

OMG! I had to replace like 5k words and I thought I needed to be a nerd in excel but with this video I did it!!!

[BlankHero]

YO! This just made what I was suppose to be doing stupid easy LOL
Like seriously, initially took me a good 30 minutes to find a replace M13 to I13 and now BOOM!
Thanks!!!

[jjones-ln]

You are amazing! I have been using Sheets to do some amazing projects at work and your videos have helped me move forward so many times!

[shellienewcomer]

this was the 1st out of 14 videos that actually explained the meaning behind the URLS. thank you, now i have quit crying.

[southbridgeforestHOA]

thank you so much I want to use a substitute command in a google form and have it automatically copy down for the entire collum. how would I do that?

[rorasins]

What if I wanted to remove certain emails. For example If I wanted to remove all emails with info, customerservice etc how would I do that?

[loumulet]

Thank you for this. Saving me so much time!!!

[hoiyinwan]

That was brilliant, thank you for making these helpful videos

[paulseldn]

Excellent. Many thanks for this excellent tutorial that will save me so much time. You went through it nice and slow too. Bless :)

[VolcanicDonut]

Is it possible to use REGEXREPLACE with an if function? Say I have a sheet where all data is stored, (names, status, confirmation, date, location) and a separate sheets for each breakdown of each status and confirmation. As the master sheets updates, is there a way to find and replace the other sheets based on the master sheet being updated (ie move names from one particular status/confirmation sheet to another based on info in the master sheet)?

[verneezymedia]

Awesome info. Love the videos. Keep up the great work!

[LemonSugarCrepe]

How can these be used in Google Docs? If I copy and paste my google document to an excel spreadsheet, when doing a find and replace with regular expressions (specifically one referring using "$1" to refer to the original text), it works fine. But the exact same find and replace in the google doc, the find is the same, and regular expressions work fine for the find, but the "$1" comes out literal. I.e. the original text is not used in place of "$1", but literally "$1" is used.

[martimoratohil]

Hi, I neet to delete all the info in a lot of cells that have wrong characters between # and #. How could you do it?

[Shahayar]

When i use find and replace function to replace text inside of cells it adds spaces in the starting and at the end of every cell

[RobertLongM]

Someone asked me to do a SEARCH/FIND in a Range and have "whatever work/phrase" that shows up - for it to be formatted with a Strike-Through. .... That's got me puzzled, unless I script it.

[Daksavedhas]

HELP ME, how to find " = " in google sheet?

[terris]

How to I replace for example EVERY 2nd occurence?

Eg, if I am replacing A to B, it would show:


to
ABABABAB

What's a good way to go about this?