Using Find and Replace is one of our Bread and Butter tools in Google Sheets. Fortunately, Google Sheets offers a lot of versatility for you to cleverly find and replace exactly what you need.

In this tutorial, we will cover,
00:00 Intro.
00:09 the basic Find tool.
02:07 Understanding the Find and Replace tool.
02:48 Using Find in the Find and Replace popup.
03:12 Basic Find and Replace
03:41 Seaching in specific ranges, sheets or the entire workbook.
06:51 Find case senstive cells.
08:02 Undoing your replace.
08:20 Find cell that matches exact string
09:39 Search using regular expressions
13:45 Search for values inside formulas.

#GoogleSheets #Spreadsheets #SpreadsheetBasics #GoogleEDU #GoogleWorkspace

Even knowing the basics can really give you the edge and save you a heap of time in the workplace.

If you like the video, check out my website:
https://yagisanatode.com/

Here is the link to just Google Sheets tutorials:
https://yagisanatode.com/google-sheets/

Sign up for my course:
Google Sheets: Learn the Essentials with Three Detailed Projects
https://yagisanatode.teachable.com/p/google-sheets

Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts.
https://www.zazzle.com.au/collections/shortcuts_mousepads-119754792503977450

Please take the opportunity to connect and share this video with your friends and family if you find it useful.