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.